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>error094640_01.xml</logFileName><summary>Errors were detected in file '\\fscommon\misc09\BI Team\Remedy BI Tool\Weekly Dashboards\CRQ\CRQ-150417.xlsm'</summary><removedRecords summary="Following is a list of removed records:"><removedRecord>Removed Records: Formula from /xl/worksheets/sheet2.xml part</removedRecord><removedRecord>Removed Records: Formula from /xl/calcChain.xml part (Calculation properties)</removedRecord></removedRecords></recoveryLog>
CABRLU63Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

broro183Commented:
hi,

I don't think that this error necessarily relates to having macros. The text log is referring to the Calculations (ie equations or formulae) on Sheet2.

- Do you have User Defined Functions (ie macro code which is used as an equation) on Sheet2?
- Do you have complicated or intensive formulae (eg Indirect or SumProduct etc) on sheet2 or ones that refer to other workbooks?

Rob
CABRLU63Author Commented:
On sheet2 I have 5 macros: 3 are for Navigation (Nav_DeleteTabularDetail, Nav_Hide and Nav_HideAllPivots) and also I have a macro PivotCacheClearRubbish and macro PivotReduceSize.
That sheet2 has Pivot Table with 4 filters and also one Pivot Chart on it, nothing more.
Brian BEE Topic Advisor, Independant Technology ProfessionalCommented:
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.
CABRLU63Author Commented:
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...
Brian BEE Topic Advisor, Independant Technology ProfessionalCommented:
I think you have the term workbook and worksheet mixed up. A workbook can be made up of many worksheets. From a windows perspective, workbook=file. So if you have multiple files with these problems, there may be some other sort of corruption causing the problem. So just to be safe I would make sure you have backup copies of these files in case the corruption becomes worse.

Anyway, as for solving this, I guess you could write a macro that opens and closes every workbook. However since this is a one time deal, it might be easier to just manually open, fix and save every workbook that has the issue. As I said, just make sure you have a backup copy of the files as they are now before you fix them.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.