Excel for MAC - We found a problem with some content in 'xxxxx.xlsx'. Do you want us to try to recover as much as we can?

Question

Hello,

I am having issues with detailed excel spreadsheets after updating to Office for Mac 16.15 in July 2018.

OS X El Capitan Version 10.11.16

Excel for Mac 16.15

When I open the file, I receive the message below.

If I hit 'Yes', the next message is:

If I hit 'View', the message is:

The spreadsheet is now corrupted for other people to read (shared via dropbox).

Alternatively, if I open an old version (saved prior to the Excel for Mac upgrade), I get a security warning:

If I 'Enable Content', the file becomes corrupt.

This is only happening to a handful of spreadsheets and began when I updated to Office 2016 for Mac Standard via the Microsoft volume licencing centre.

Can you please provide advice?

Thanks

Answer 1

Hello,

Neither the finance director or I know of any Pivot Tables in the budget spreadsheets and therefore cannot update  source files.

I have given up and deleted the corrupted files.  I've started new budget files from scratch - transferring data / values from one spreadsheet to the new one.

Jo

Answer 2

That's your issue although you copy to, and archive to, any cloud service. Office365 for Mac Only allow editing without corruption use One Drive only. Naturally being a Microsoft product they set the rules for use.  You can use other service but you have to use this procedure in order to work.

1. From your Cloud service copy your document back to your Computer.
2. Work on Document from your computer. (not the version on DropBox.)
3. Save changes to document on the computer.
4. Upload to Dropbox.

The person on the other end, use the same procedure.

1. If you use One Drive in Template view click on open choose OneDrive Personal (or Business).
2. Make sure you are signed in to OneDrive.
3. Create Document and Save to specified area on OneDrive.

Once you tell the other party how to locate the document and set to use OneDrive. Both should be able to save on OneDrive directly.

__________

Disclaimer:

The questions, discussions, opinions, replie & answers I create, are solely mine and mine alone and do not reflect upon my position as a Volunteer Moderator.

Answer 3

Thank you for your reply, but that is not satisfactory. 

Dropbox for Business has been used by the company for five years and we share hundreds of excel spreadsheets.  The issue being encountered has only began since updating to Excel for Mac 16.15 and is only occurring with spreadsheets with multiple worksheets.

Is there another explanation and resolution for the issue?

Thanks

Answer 4

Tomorrow version 16.16 should become available. Install that version and then test again.

Answer 5

Hi JoQld,

Does the problem still persists in version 16.16?

Regards,

Tisky