CABRLU63
asked on
Excel found unreadable content in file error.
I started getting this error in my Excel file with some macros.
"Excel found unreadable content in file error. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes"
Then I click Yes.
Then window with this appears:
"Repairs to file
Excel was able to open the file by repairing or removing the unreadable content.
Removed Records: Formula from /xl/worksheets/sheet2.xml part
Removed Records: Formula from /xl/calcChain.xml part (Calculation properties)"
And here is the long that they provide in the link:
<?xml version="1.0" encoding="UTF-8" standalone="true"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>erro r094640_01 .xml</logF ileName><s ummary>Err ors were detected in file '\\fscommon\misc09\BI Team\Remedy BI Tool\Weekly Dashboards\CRQ\CRQ-150417. xlsm'</sum mary><remo vedRecords summary="Following is a list of removed records:"><removedRecord>R emoved Records: Formula from /xl/worksheets/sheet2.xml part</removedRecord><remov edRecord>R emoved Records: Formula from /xl/calcChain.xml part (Calculation properties)</removedRecord ></removed Records></ recoveryLo g>
"Excel found unreadable content in file error. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes"
Then I click Yes.
Then window with this appears:
"Repairs to file
Excel was able to open the file by repairing or removing the unreadable content.
Removed Records: Formula from /xl/worksheets/sheet2.xml part
Removed Records: Formula from /xl/calcChain.xml part (Calculation properties)"
And here is the long that they provide in the link:
<?xml version="1.0" encoding="UTF-8" standalone="true"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>erro
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Is this happening with multiple workbooks? Just wondering more about the cause than the fix.
Once you tell Excel to fix the file, does the error go away next time? If not, another way to fix a bad workbook is either to save it as an older Excel format, or try creating a new workbook and copy all the contents there.
Once you tell Excel to fix the file, does the error go away next time? If not, another way to fix a bad workbook is either to save it as an older Excel format, or try creating a new workbook and copy all the contents there.
ASKER
Q: "Is this happening with multiple workbooks? Just wondering more about the cause than the fix."
A: Yes, my worksheet has 30+ workbooks.
Q: "Once you tell Excel to fix the file, does the error go away next time? If not, another way to fix a bad workbook is either to save it as an older Excel format, or try creating a new workbook and copy all the contents there."
A: Yes, you're correct. Once Excel fixes the error and I save this file (overwite the current, bad one) the error then dissapears from the sheet. Problem is that I need to do this process in my automated macro, that adds additonal tasks that I didn't have to perform prior this dissaster...
A: Yes, my worksheet has 30+ workbooks.
Q: "Once you tell Excel to fix the file, does the error go away next time? If not, another way to fix a bad workbook is either to save it as an older Excel format, or try creating a new workbook and copy all the contents there."
A: Yes, you're correct. Once Excel fixes the error and I save this file (overwite the current, bad one) the error then dissapears from the sheet. Problem is that I need to do this process in my automated macro, that adds additonal tasks that I didn't have to perform prior this dissaster...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That sheet2 has Pivot Table with 4 filters and also one Pivot Chart on it, nothing more.