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 text. Change rId2 to rId1 and save. Then change the .zip extension back to the Excel file extension (such as .xlsx), open the workbook, and save it. If you send this workbook to others or change the save location of the workbook, the pivot table can be refreshed normally.

Notes

If there is more than one pivot table, please change the pivotCacheDefinition X.xml file in sequence. Change rId X to the rId corresponding to the cache set.

X represents a number

The 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!