Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office => Change Zip to XLSBĬonfiguration Analyzer Tool (OffCAT), which is developed by Microsoft Support teams. =>Double click the Zip=>Go to test one1.zip\xl\pivotCache\pivotCacheDefinition1.xml => Open pivotCacheDefinition1.xml in Notepad.=> Find => change rId2 to rid1. Thus, please try the 2 workarounds:Ĭreate a copy of file as test file =>Change the file edition from XLSB to ZIP. If we renamed the file, Excel could not find the original file name. After we closed the file, Excel 2013 generated the full name and path of the data source and stored in ![]() ![]() As far as I know, this issue might be caused by the Excel file contain the personal information(data source), such as Access database name, path.
0 Comments
Leave a Reply. |