-
-
Notifications
You must be signed in to change notification settings - Fork 1.7k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
PivotTable: Refresh cache of PivotTable(s) #597
Comments
@xuri D you have any ideas how to refresh the pivot tables? I can implement it, but I need some hints where to start. |
@mvanwaaijen Do you know any other go libraries, that can work with pivot tables? I need to edit an excel file, that contains the pivot tables, and after the saving I would like to see the updated pivot tables. |
@SVilgelm For now you can have your templates checked 'Refresh data when opening the file'. That way when you save changed excel file through code, when you open it with Excel will be automatic refreshed. |
@drsasa thank you! |
I see there is already a solution. I am not aware of any other packages that can do all this... |
As of now, you can only add a new pivot table with the AddPivotTable function and not reference an existing pivot table. I am looking for a way to refresh the cache of the pivottable for instance by calling a RefreshPivotTables() function or something like that to refresh the cache when the underlying data an existing pivot table has been changed...
The text was updated successfully, but these errors were encountered: