Pivot Tables not recalculating

Aspose.Cells Product Family
1

I’ve attached a working console app that demonstrates the problem. It opens an existing file, puts new data into a ListObject that the Pivot table is based upon. Then it recalculates the pivot and saves as new file.



When you open the new file, you will see the new data and the pivot. If you place your cursor in the pivot table and refresh, then you will see that it had not been recalculated before saving.



Thanks for your help,

Rick

2

Hi,


Thanks for your posting and using Aspose.Cells.

We were able to observe this issue and logged it in our database for a fix. I have also attached the output excel file generated by your project for a reference.

This issue has been logged as

  • CELLSNET-44807 - Pivot Table is not getting calculated or refreshed

3

@rick855d4,
Please try our latest version/fix: Aspose.Cells for .NET v21.6.3 (attached)
Aspose.Cells21.6.3 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells21.6.3 For .Net4.0.Zip (5.5 MB)
Aspose.Cells21.6.3 For .NetStandard20.Zip (5.5 MB)

Your issue should be fixed in it.
Let us know your feedback.