One Excel 2010 user corrupts spreadsheets

[anthonycar]

Hey guys, hoping for some insight on an issue I am facing:

We have one user that is running Excel 2010. When she opens a spreadsheet, works on it, then saves it, it opens with errors the next time anyone tries to use it. It gives an “Unreadable content error message” and asks if you want to repair the file. It seems to only happen if she saves it as .xlsx, saving it as .xls doesn’t seem to cause the same problem.

Exact Error:

“Excel found unreadable content in filename.xls. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.”

She is running Office 2010 Home & Business on Windows 7 Pro x64

I have tried repairing Office 2010, uninstalling and reinstalling Office 2010, making sure it has the latest updates and service packs.

Any insight into this issue would be greatly appreciated!

Thanks

[axioma]

Mmmm, looks like you are asking at the wrong tree…

Have you tried to open the files in LIbreOffice?

[peter_newton2]

So I assume that all except 1 uses Excel 2003…

Excel 2007 an later are Zipped XML files

so excel 2003 can’t (we’ll at least it can encounter problems)open higher versions you have to save the file “for compatibility”
…Go to Save as, be sure that the check box in “Check for compatibility when saving this workbook” is ticked. Redirecting to Google Groups