Home >Common Problem >How to solve the problem that the PivotTable source file cannot be opened
The solution to the inability to open the pivot table source file: first change the file extension from ".xlsx" to ".zip"; then modify the "pivotCacheDefinition1.xml" file; finally extend the ".zip" Just change the name back to Excel.
When refreshing the PivotTable, it prompts that the PivotTable source file cannot be opened
Change the location of the workbook where the PivotTable is located in Excel or send it to Others, when refreshing the PivotTable, it prompts:
Method
Change the file extension from .xlsx to .zip
Double-click to open the compressed package, expand xl/pivotCache in order, find the pivotCacheDefinition1.xml file, and then open the file with Notepad.
##Search rId2 and find the following textThe above is the detailed content of How to solve the problem that the PivotTable source file cannot be opened. For more information, please follow other related articles on the PHP Chinese website!