About Quomon
Quomon is a network of IT professionals from around the world, collaborating by sharing knowledgeable answers in their specific field of expertise.
I have built Pivot Tables in MS Excel and saved the file in .xlsx. Next day, I tried to access the same file and facing these errors:
“We found a problem with some content in <filename>. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes”
After clicking on ‘Yes’ button. I have faced another errors:
“Removed Part: /xl/pivotCache/pivotCacheDefinition1.xml part with XML error
(PivotTable cache) Load error. Line 2, column 0
Removed Feature: PivotTable report from /xl/pivotTables/pivotTable1.xml part (PivotTable view)”
After searching over internet, I get to know that my Pivot table is corrupted. So, to solve this error I tried manual method which are available on sites & forums.
Firstly I opened MS Excel in Safe Mode then copy all the contents of excel sheet includes pivot table in new worksheet and save it. To save pivot table right click on pivot table and click on pivot table options. Then on the display tab, click the check box labelled “Show Properties in ToolTips” and at the end save the file with the new settings. But after doing all these process I faced same issue.
I have referred these resources:
https://www.stellarinfo.com/repair-excel-file.php
Please provide best solution to fix this error.
Quomon is a network of IT professionals from around the world, collaborating by sharing knowledgeable answers in their specific field of expertise.