Thanks for your inquiry.
Well, if you do not use the macros in the template file, you may try to delete the macros using the API i.e…, Workbook.RemoveMacro() method.
If you still find any issue, kindly post your template excel file, created excel file and sample code to reproduce the issue, we will check it soon.
I’m not sure you understood. There are no macros in the spreadsheet and if possible we want it to stay that way.
Could you post your generated file here, we will check it soon.
After further investigation, we found the issue is actually caused that we do not support to read the pivot table from the template file. If the pivot data source is updated, the preserved data range could not contain all data of the pivot table:
1) In MS Excel, if there’s any data or style to be set for the pivot data range, it will appear.
2) In MS Excel 2007, it always appears.
We are working on reading the pivot table from the template file currently, so we might support this feature in our future versions.
Thanks for your patience.
Thanks for your quick reply.
Hopefully, we will complete the feature in Q1 2010.
I think, this issue has been resolved in the latest version:
Aspose.Cells for .NET v126.96.36.199
please try it and share the feedback.
Let us know the demo you are particularly referring to. We will look into it and fix the code.
I have the same issue. I just tested our pivot table with Aspose.Cells DotNet 7.0.2 and the issue is not resolved. Please let me know when you have a fix.
Please try pivottable.RefreshData() to refresh the pivot source.
And if the issue is still there please provide us your sample file and code.