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

Free Support Forum - aspose.com

Error with Pivot Table Connections in an XLSM file using Aspose.Cells:

We have an issue with Pivot Table Connections in an XLSM file using the latest version of Aspose.Cells:

I have tested this with simply:
string tempSaveLocation = @“C:”;
new License().SetLicense(“Aspose.Total.lic”);
Workbook workbook = new Workbook(tempSaveLocation + “Report.xlsm”);
workbook.Save(tempSaveLocation + “Reportout.xlsm”, SaveFormat.Xlsm);

The error relates to pivot table connections.
To reproduce:
1) Go to the ‘Bursts’ worksheet on the Report form and right-click on the ‘Bronze Area’ slicer
2) then click on ‘Pivot Table Connections’, you will see there are 6 connections. 4 of these are associated with the ‘Bursts - PrintOut format’ sheet. These are used to pass the filters which are selected into the print out sheet.
3) Go to the ‘Bursts’ worksheet on the Reportout form and right-click on the ‘Bronze Area’ slicer, then click on ‘Pivot Table Connections’. You will see that the 4 connections associated with the print out sheet are no longer associated. Trying to re-add these displays the error:
"One or more of the pivot tables chosen are created in a version of Excel earlier than Excel 2007 or in compatibility mode. Slicers can only be used with PivotTables created in Excel 2007 or a newer version of Excel."

There are differences in the file size between the input file (611KB) and the output file (580KB).

Thanks for your help


It looks like an issue as you have described. I have logged a ticket with an id: CELLSNET-40162. We will soon look into it.

Thank you.

The issues you have found earlier (filed as CELLSNET-40162) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.