Im using Aspose Cells for .NET. (version 7.2.0)
I want to refresh an existing Pivot Table in a template workbook without opening it.
I know that we can refresh Pivot tables when opening workbooks by setting the property pivotTable.Cache.IsRefreshOnLoad = true, and then when we open the workbook the pivot table data will be refreshed based on the data in the data source worksheet.
But in my case i want to refresh the Pivot Table in code, so i can send it in email.
Is there a solution for this ? If not is there a workaround to achieve this ? (Recreate the pivot table maybe ? or maybe save the workbook and reopen it in code)