Hi,
We are experiencing an issue with pivot tables; When a compact pivot table is updated using “CalculateData()” the resultant file seems to have the data in the wrong place. Instead of having a column one column to the left when the pivot table has one column pair in compact mode, the resultant file’s pivot table’s data is in tabular mode (only the pivot table itself is in compact mode).
I have attached a small project to demonstrate this issue. I have also attached an input file “input file compact pivot table.xlsx” for you to use.
The attached screenshot shows the difference in the files.