Excel 2013: Error opening saved PivotTable reports from PWA BI Center

A problem that has been around for a little while has ben when re-opening a PivotTable that was created from the OLAP templates within the Business Intelligence (BI) Center within Project Web App (PWA) you will see an error – We found a problem with some content in ‘NameofSpreadsheet.xlsx’. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.  As much as we could recover was generally nothing – perhaps some text remained but the PivotTable was gone…

Error message containing the text - We found a problem with some content in ‘NameofSpreadsheet.xlsx’. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes

Clicking Yes would bring up a second dialog title Repairs to ‘NameofSpreadsheet.xlsx’ containing the text something like:

Removed Part: /xl/pivotCache/pivotCacheDefinition1.xml part with XML error.  (PivotTable cache) Load error. Line 2, column 0.
Removed Feature: PivotTable report from /xl/pivotTables/pivotTable1.xml part (PivotTable view)

This has been fixed by an Excel update – and as near as I can tell version 15.0.4517.1001 will get you past this issue.  This can be found via KB 2817339 - http://support.microsoft.com/kb/2817339/en-us.

Also please note that the bad stuff appears to happen on save – so if a saved xlsx is already giving this error then a patched Excel won’t recover it – but just allow you to save a new one that won’t get corrupted.

If you use click 2 run then you will likely already have been patched to this level or beyond.

Comments (8)

  1. anonymouscommenter says:

    this is incorrect, the issue still persists in build 15.0.4517.1504. However there is a workaround posted by adrian_rho, here:


    "Create your PivotTable as usual. Then Right Click on the PivotTable / Click PivotTableOptions / On the Display tab, clear the checkbox labeled “Show Properties in ToolTips.” Of course, this needs to be done before the PivotTable is corrupted."

    So this workaround can only be done once the pivot is created, and before saving. If you have already saved and closed, then the pivot will be lost.

  2. Can you give me steps Mike?  It won't fix a broken one – but for me this fix level did not give the issue.

    Best regards,


  3. anonymouscommenter says:

    I’m having this issue with 15.0.4551.1512. However, if I accept repairs/etc., all my data is intact and working. It’s more of a nuisance than anything else. Will there be an ACTUAL fix anytime soon?

  4. anonymouscommenter says:

    Hi Brian, is there a fix to this problem? we are trying to migrate our users to excel 2013 but this issue has been causing concerns as the file gets corrupt specially if people don’t know the workaround at the first place.
    Thanks for your help on this in advance.

    Best Regards,

  5. anonymouscommenter says:

    Excel 15.0.4649.1003, the issue is still there. Is there any fix available? Existing workarounds do not help.
    the message is a bit different this time: Removed Part: /xl/pivotTables/pivotTable1.xml part. (PivotTable view)

  6. Adrian says:

    Hi all, I’m running Excel 2013 (15.0.4569.1504) here now in January 2017. To my (and my IT dept’s) knowledge this is the most up to date version of Excel 2013 and I am still encountering the exact issue as above. Has anyone resolved this issue using any other methods? The workaround in the previous comments does not work for me as the check box labeled “Show Properties in ToolTips” is greyed out in my pivots.


    1. JanC says:

      I am also experiencing this problem using data coming from an Oracle DB. I have tried removing all the date fields (as they are mentioned as a culprit in https://blogs.technet.microsoft.com/the_microsoft_excel_support_team_blog/2013/03/22/problem-reopening-excel-2013-pivottable-workbooks/), but that did not help me.
      Can we please have MSFT look at this, this is extremely annoying!

Skip to main content