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

Free Support Forum - aspose.com

Issue with refreshing pivot tables in version 7.1.2.0

Hi

We recently migrated to ASPOSE 7.1.2.0 from 7.1.0.5 to fix one of our issue, but it seemed that refresh pivot table corrupt the excel files. We have attached the file for you to test and also the error message from Excel.

The core code we use to reproduce this bug is:

foreach (Aspose.Cells.Worksheet worksheet in workBook.Worksheets)

{foreach (Aspose.Cells.Pivot.PivotTable pivotTable in worksheet.PivotTables)

{

pivotTable.RefreshData();

pivotTable.CalculateData();}

}

We have a deployment scheduled this weekend and this is an critical item that could stop the deployment. Could you take a look and see if it is possible to fix it ASAP? Much appreciated for you support effort!

Regards

Bill

Hi,

It appears this issue has been fixed in version 7.1.2.6. We are all good now:)

Regards

Bill

Hi,

Thanks for your posting and using Aspose.Cells for .NET

It’s good to know that latest version has already fixed the problem.

If you face any other problem, please feel free to post, we will help you asap.