Microsoft Project Support Blog

The place to come for Microsoft Project, Microsoft Project Server and Project Online support topics

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

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

  • Comments 6
  • Likes

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
  • Nice Work.

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

    social.technet.microsoft.com/.../project-server-2013-olap-data-connection-problem

    "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.

  • 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,

    Brian

  • 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?

  • 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,
    Aman

  • 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)

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment