Answer
This question has not yet been answered.
Pivot Table Error
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.
Status:
Open Sep 27, 2018 - 02:31 AM
Do you have the same question? Follow this Question
Share Your Own Experience & Expertise
We look to ensure that every question is answered by the best people with relevant expertise and experience, the best answers include multiple perspectives. Do you have relevant expertise or experience to contribute your answer to any of these commonly asked questions?
Add New Comment