We have an issue with Pivot Table Connections in an XLSM file using the latest version of Aspose.Cells: 7.0.3.3
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