Behaviors of pivot table changed after saving

Posted by: yyoshimura on 7 April 2021, 7:04 pm EST

  • Posted 7 April 2021, 7:04 pm EST


    We noticed that the behaviors of pivot table changed after saving using the API.

    Reproduction steps:
    1. Create a workbook with pivot table (We are using SSAS data source).
    2. Expand the result like following.

    3. Save the workbook using API
    4. Open the file again, the pivot table will be changed like following.

    We hope that the behavior of pivot table should be the same after saving.
    Please help to investigate this issue. Thank you.

    The program used to generate the files is as following.
  • Replied 8 April 2021, 5:30 pm EST


    We do not face the issue at our end with the latest build 4.0.5 by running your attached sample.
    If you are not using the latest API then please check once with it and if the issue still occurs then please share the environment details and MS Excel version on which you are opening the saved excel.

    Prabhat Sharma.
  • Replied 8 April 2021, 6:44 pm EST

    We can confirm that the problem still occurs with the latest build v4.05.

    Sorry for omitting some very important prerequisites.

    You need to connect to a working SSAS data source. The problem occurs after the first successful update of the pivot table.

    The attached sample Excel file cannot be reproduced because it is connecting to our internal testing SSAS database. We cannot find an open SSAS data source online to provide a working reproduction. Hope that the point was made clear and sorry for the inconvenience.
  • Replied 8 April 2021, 7:16 pm EST

    We have made a reproduction video. Please refer attachment. Thank you.
  • Replied 8 April 2021, 7:20 pm EST

    And this is a video with the file before saving with API which is working as expected.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels