We found a problem with some content .xlsx error. Then> The file is corrupt and cannot be opened.

Question

After downloading an .xlsx file from the web and trying to open it with Excel 2016 (and 2013), I am experiencing an error that reads: 

"We found a problem with some content <nnnn>.xlsx. Do you want us to try and recover as much as we can?" error.

When I click Yes, I get another error that reads "The file is corrupt and cannot be opened."

I've clicked off all of the protected view settings in the Trust Center Settings, and Clicked "Unblock" from the file properties in Windows Explorer, but continue to get the error. 

This same file opens fine when a user saves it as .xls and I download and open that file. 

Anybody have any other clues as to settings to check?

Thanks.

Jim

Excel 2016, 2013

Answer 1

Hello,

Thank you for your reply.

I suggest you to refer to the suggestion mentioned by Vijay A. Vermaand Rohn007 in below mentioned link on similar issue to check if it helps.

http://answers.microsoft.com/en-us/office/forum/office\_2016-excel/file-is-corrupt-and-cannot-be-opened-in-excel-2016/3e378431-83c6-474e-a852-eaea3bb802a8/

Please post back with the updated issue details for further assistance.

Thank you.

Answer 2

I stumbled upon this item from the menu under design and within External Table Data "Unlink". I clicked on it and it became grayed out. I then made changes to the spreadsheet and saved-closed and was able to reopen just fine.