Help Desk
asked on
One Excel 2010 user corrupts spreadsheets
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,
Kevin
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,
Kevin
ASKER
All users are running Windows 7 Pro x64 and either Excel 2010 or 2013.
Have not tried running Excel in safe mode but will give that a try thanks.
Have not tried running Excel in safe mode but will give that a try thanks.
Is your file on a local drive or a network drive?
Is there any disk encryption involved?
Is there any disk compression involved?
Are multiple users opening the Excel file?
Do you have any large Pivot tables involved?
Do you have any large data connections to a database involved? If yes, what kind of database? Access or MSSQL etcetera
Is there any disk encryption involved?
Is there any disk compression involved?
Are multiple users opening the Excel file?
Do you have any large Pivot tables involved?
Do you have any large data connections to a database involved? If yes, what kind of database? Access or MSSQL etcetera
ASKER
1. Network drive
2. No
3. No
4. Yes
5. Will have to verify but I believe some of them are using pivot tables
6. Some are linked to other spreadsheets but no database linking that I know of
2. No
3. No
4. Yes
5. Will have to verify but I believe some of them are using pivot tables
6. Some are linked to other spreadsheets but no database linking that I know of
Is this by chance a shared workbook?
ASKER
You say> it seems to only happen if she saves it as .xlsx, saving it as .xls doesn't seem to cause the same problem.
This is the new format for Microsoft Office documents.
and is a combination of XML architecture and ZIP compression for size reduction.
the exact error is>"Excel found unreadable content in filename.xls"<< that says .xls not .xlsx
A bit of discrepancy here.
Which .xls is being used? that could cause a problem with .xlsx
since there is a few to choose from. Could be relevent?
Microsoft suggests
Start Excel.
Select File > Options.
Click Advanced on the left hand side of the Excel Options dialog.
Scroll down to the General section.
Make sure that the check box "Ignore other applications that use Dynamic Data Exchange (DDE)" is clear (NOT ticked).
Click OK.
See if there is any updates office.
Any updates for your windows and Microsoft products.
All Fonts are correct.
Seems to be a problem with .xls not so much the.xlsx
This is the new format for Microsoft Office documents.
and is a combination of XML architecture and ZIP compression for size reduction.
the exact error is>"Excel found unreadable content in filename.xls"<< that says .xls not .xlsx
A bit of discrepancy here.
Which .xls is being used? that could cause a problem with .xlsx
since there is a few to choose from. Could be relevent?
Microsoft suggests
Start Excel.
Select File > Options.
Click Advanced on the left hand side of the Excel Options dialog.
Scroll down to the General section.
Make sure that the check box "Ignore other applications that use Dynamic Data Exchange (DDE)" is clear (NOT ticked).
Click OK.
See if there is any updates office.
Any updates for your windows and Microsoft products.
All Fonts are correct.
Seems to be a problem with .xls not so much the.xlsx
ASKER
The screenshot above show the error while opening .XLSX, not .XLS.
We will try the above DDE option and will report back.
Please share any other thoughts, as this issue has been unresolved for nearly 4 weeks now.
Thanks
We will try the above DDE option and will report back.
Please share any other thoughts, as this issue has been unresolved for nearly 4 weeks now.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
We have resolved this internally.
Are all of the other users using the same environment (MS-Office version &, specifically, a 64-bit version of Windows [7 Pro])?
Also, if the user that experiences the issue opens MS-Excel (2010) in "Safe Mode" (depressing the [CTRL] key when launching the application from a shortcut or from the Windows Start Menu until a message is displayed, as below), does the same issue exist?
BFN,
fp.