Pivot Table Excel 2016 Saved Onedrive

Question

Hi team

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error108600_01.xml</logFileName><summary>Errors were detected in file 'https://orgname.sharepoint.com/personal/user@tiedtlaw email .com/aaa/bbb/ccc/DDD/EEE/FFF/ggg/hh SE'</summary><additionalInfo><info>PivotTable report 'PivotTable3' on '[filename.xls]Pivot table and calcs' was discarded due to integrity problems.</info></additionalInfo></recoveryLog>

Error reported when using pivot tables. Document saved to personal Onedrive. When saved to local disk the pivot works.

What could be the cause for pivot to not work?

Thank you for your help in advance

Answer 1

Hi @Mayson Arnagiri ,
Did you mean when you try to download Excel Workbook from OneDrive to local, the PivotTable didn't not work?
What kind of data source did you use for the PivotTable?
Did the data source store in existed Workbook?
I suggest you try to create a new Workbook in local with the same data source and PivotTable and let me know the result.
Please be a bit more precise to explain your problem so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

@Emi Zhang-MSFT

Thank you for your response,

The file is saved to Onedrive, when accessed and pivot table used, the results are not correct.
When the file is copied to local disk the pivot table works

Thanks Mayson