Shulou(Shulou.com)06/02 Report--

Xiaobian to share with you how to solve the problem of unable to open the pivot table source file, I hope you read this article after the harvest, let us discuss it together!

Workaround for unable to open Pivot table source file: first change file extension from ".xlsx" to ".zip"; then modify "pivotCacheDefinition1.xml" file; finally change ".zip" extension back to Excel.

Cannot open Pivot source file when Pivot refreshes

Change the position of the workbook where the Pivot Table is located in Excel or send it to others. Prompt when the Pivot Table is refreshed:

method

Change file extension from.xlsx to.zip

Double-click to open the archive, expand xl/pivotCache in turn, find the pivotCacheDefinition1.xml file, and then open the file with Notepad.

Search for rId2 and find the following text. Change rId2 to rId1 and save. Change the.zip extension back to an Excel file extension (such as.xlsx), open the workbook, and save it. Distribute this workbook to others, or change the location where the workbook is saved, and the pivot table refreshes normally.

precautions

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

X stands for number.

After reading this article, I believe you have a certain understanding of how to solve the problem of not being able to open the source file of the Pivot Table. If you want to know more about it, welcome to pay attention to the industry information channel. Thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.