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

[MissingVanSushi]

[FONT=&quot]Hello there,[/FONT]
[FONT=&quot]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.[/FONT]
[FONT=&quot]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/[/FONT]
[FONT=&quot]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.[/FONT]
[FONT=&quot]Has anyone else on this sub encountered this type of error before and did you find a solution?[/FONT]
[FONT=&quot]Thanks[/FONT]

 

[MissingVanSushi]

Not sure if this is frowned upon but *bump* for visibility.