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

Free Support Forum - aspose.com

"Index out or range" exception when refreshing Pivot Tables


Please find attached a source-code example that loads an XLSX file and refreshes the pivot tables on every worksheet; that fails with an index out of range exception. Tested with the newest (20.1) release as well with 19.11 and 19.12 - the exception keeps coming in all versions.

Kind Regards,

Aspose.ErrorMsg.zip (5.2 MB)

We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-47122 – "Index out of range" exception when refreshing Pivot Tables

This is to inform you that we have fixed your issue (logged earlier as “CELLSNET-47122”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.


Please try our latest version/fix: Aspose.Cells for .NET v20.1.4 (attached)

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells20.1.4 For .Net2_AuthenticodeSigned.Zip (5.0 MB)
Aspose.Cells20.1.4 For .Net4.0.Zip (5.0 MB)


That seems to have fixed the issue, thx. Will this be included in 20.2? Or is it already safe to roll out 20.1.4 to customers?


Thank you for the feedback. This fix is passed through all the tests which are performed for a regular release. You may please use it in your production environment as per your needs.

Moreover this fix will be included into v20.2.

The issues you have found earlier (filed as CELLSNET-47122) have been fixed in Aspose.Cells for .NET v20.2. This message was posted using Bugs notification tool by Amjad_Sahi