Posted 7 April 2021, 7:04 pm ESTHi
We noticed that the behaviors of pivot table changed after saving using the API.
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.