Excel could not open because some content is unreadable
We use a collaborate Google Sheets to mark daily hours we spend on specific projects. Every month, I create a pivot table to tally the numbers/project. I want to back up this table for my records in an Excel workbook. When I download as .xlsx, I get an error message "Excel could not open .... because some content is unreadable". Then I click "Open and repair", and it says "Excel repaired or removed unreadable content from this workbook. Do you want to review or save the log file?". Therefore, I can assume some of my data is lost.
Why does this happen? Is there a workaround? I tried changing the format to .xls, but I get the same errors.
I am using version 14.6.1
sam tes commented
I have the same problem.I am trying to an excel file forwarded by my colleague.
I cannot open th excel file and it just freezes the application with the following windows pop out "Excel could not open FILENAME.xlsx because some content is unreadable. Do you want to open and repair this workbook?
after I pressed "open and repair", the application just hangs there, and I have to force the application to quit.
I have tried opening the same file in a windows machine and it is working like normal.
At the end I tried the chat with your support team, they did the Remote Desktop thing to find the error. At the end, they cannot solve the issue and told me to wait for the next office update. And this is the next place where I can hope for. So the developer for Excel out there, do help!