Please make this post public now.
i cannot see any button to Make public.
on reply also “Keep this post private” is disabled for me.
Thanks for your posting and using Aspose.Cells for .NET.
We have fixed the issue.
Please download and try this fix: Aspose.Cells for .NET v188.8.131.52 and let us know your feedback.
Still the issue is partially solved.
Thanks for using Aspose.Cells.
Please add this sample code before saving:
for (int i = 0; i < book.Worksheets.Count; i++)
Worksheet sheet = book.Worksheets[i];
if (sheet.PivotTables != null && sheet.PivotTables.Count > 0)
for (int j = 0; j < sheet.PivotTables.Count; j++)
PivotTable table = sheet.PivotTables[j];
This all i have done and have in my code but still we are having this issue so please fix it from your side.
Dim pchart As Aspose.Cells.Charts.Chart
''refreshing pivot tables and charts from all worksheets
For Each ws As Aspose.Cells.Worksheet In myWorkBook.Workbook.Worksheets
For Each pivot In ws.PivotTables
pivot.PreserveFormatting = True
For Each pchart In ws.Charts
please reply me on this
Please try our latest version/fix: Aspose.Cells for .NET v21.6.3 (attached)
Aspose.Cells21.6.3 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells21.6.3 For .Net4.0.Zip (5.5 MB)
Aspose.Cells21.6.3 For .NetStandard20.Zip (5.5 MB)
Your issue should be fixed in it.
Let us know your feedback.