• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Error: We found a problem with some content in 'Book1.xlsx'. Do you want us to try to recover as muc

M

MissingVanSushi

New Member
Hello there,

My company uses a SQL server to store large amounts of data and I've built several dashboards that use pivot tables linked to the database. Lately on a few of my files I encounter this error and then if I select "Yes" then all or some of my pivot tables are removed and revert to flat tables with hard coded values.

The same issue is reported here stating it was fixed in an update but I am on Office 2013 SP1 and I'm still having this issue.https://blogs.technet.microsoft.com...-saved-pivottable-reports-from-pwa-bi-center/

To be exact I am running Microsoft Excel 2013 (15.0.4569.1504). I also tried the workaround suggested in the comments on that link involving clearing the check box labelled "Show Properties in ToolTips" but this does not work.

Has anyone else on this forum encountered this type of error before and did you find a solution?

Thanks
 
Last edited:
I've never seen that but reading the articles it sounds like it only affected spreadsheets saved by that particular update.

Do you have access to a file with Excel 2016

Newer Excel versions have better file recovery options

Beyond that you will have to rebuild the Pivot Tables
 
You must log in or register to reply here.
Back
Top