Posted 7 April 2021, 7:04 pm EST - Updated 29 September 2022, 6:34 am EST
Hi
We noticed that the behaviors of pivot table changed after saving using the API.
Reproduction steps:
- Create a workbook with pivot table (We are using SSAS data source).
- Expand the result like following.
- Save the workbook using API
- 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.
gcexcelperformance.zip