Repairing the corrupt pivot table of MS Excel File

How to repair corrupt pivot table of MS Excel file? SOLUTION: • Open the Excel File in a safe mode and then check if you can access the Pivot Table. • If you can, save all its contents to a new Pivot Table in the latest version of Excel so that this problem doesn’t arise anymore. If it doesn’t work, then: • Right Click on the PivotTable and click on PivotTableOptions • On the Display tab, clear the checkbox labelled “Show Properties in ToolTips” • Save the file with the new setting intact • If the above steps don’t work too, open the Pivot Table Options window by right- clicking on the Pivot Table within an Excel file and select Pivot Table Options from the pop-up menu.

Comments

Saved me a lot of time, thanks!
Kresimir Kasal - Mon, 12/16/2019 - 04:13 :::
1 answer

Good Explanation, how to resolve the task

Comments

Saved me a lot of time, thanks!

Kresimir Kasal - Mon, 12/16/2019 - 04:12 :::