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 error:
“Removed Part: /xl/pivotCache/pivotCacheDefinition1.xml part with XML error
(PivotTable cache) Load error. Line 2, column 0Removed Feature: PivotTable report from /xl/pivotTables/pivotTable1.xml part (PivotTable view)”
After searching over the internet, I get to know that my Pivot table is corrupted. So, to solve this error I tried the manual method which is available on sites & forums.
Firstly I opened MS Excel in Safe Mode then copy all the contents of excel sheet includes pivot table in a new worksheet and save it. To save pivot table right click on the pivot table and click on pivot table options. Then on the display tab, click the checkbox labeled “Show Properties in ToolTips” and at the end save the file with the new settings. But after doing all these processes I faced the same issue.I have referred these resources for using the manual method:
https://social.technet.microsoft.com/Forums/office/en-US/fde84737-23fc-40f2-a582-2f77713882a5/excel-pivot-tables-getting-corrupted-in-excel-2010-after-saving-the-changes-made-and-reopening?forum=excel
http://office.microsoft.com/en-us/excel-help/use-office-excel-2010-with-earlier-versions-of-excel-HA010342994.aspx
https://www.stellarinfo.com/repair-excel-file.php
https://answers.microsoft.com/en-us/office/forum/office_2010-excel/refreshing-pivot-tables-causes-the-file-to-become/82f80e63-fb6a-4f1f-aae5-40dac714301a?db=5Please provide the best solution to fix this error.