Pivot Table Excel 2016 Saved Onedrive

Mayson Arnagiri 1 Reputation point

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

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,520 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Emi Zhang-MSFT 17,231 Reputation points Microsoft Vendor

    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.

    0 comments No comments

  2. Mayson Arnagiri 1 Reputation point

    @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