See attached sample: I call “Worksheet.RefreshPivotTables()”, which brings three problems:
AsposeCellsPivot.zip (26.3 KB)
Problem 1
In the source file, the filter for cell B6 is set to single select. After applying “R…...table to refresh when the document is loaded (and not to store...which the workbook is being processed. Ensure that the locale settings...