We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Error when recalculating a pivot table

Hi guys
I have a problem recalculating a pivot table.
There is always an error when I run the method “CalculateData”.
Can you check if this is a bug, because Excel doesn’t make any problems here.
I have attached a small example, when you run it, the error message appears.
I use the latest version of Aspose Cells (21.4.0).
PivotTableExample.zip (5.8 MB)

Thanks for your support.

@akquinet,
We have observed this issue here and logged a ticket in our database for further investigation. You will be notified here once any update is ready for sharing.

This issue is logged as:
CELLSNETCORE-114 - Error when calculating a pivot table

@akquinet,

We are working over your issue. Once we figure it out, we will provide you the fixed version after performing QA and incorporating other enhancements and fixes.

Thanks for the support, I will test it then.

@akquinet,

We are pleased to inform you that your issue has been resolved. We will provide the fixed version in the next few days (3-5 days or so) after performing QA and incorporating other enhancements and fixes.

@akquinet,
Please try the latest fix 21.5.1.
Aspose.Cells21.5.1 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells21.5.1 For .Net4.0.Zip (5.5 MB)
Aspose.Cells21.5.1 For .NetStandard20.Zip (5.5 MB)

Good Job, it works fine.

@akquinet,

Good to know that your issue is sorted out by the suggested fix. In the event of further queries or issue, feel free to write us back.