I'm currently working on a Java application that uses a template excel file that contains a pivot table.
The template file also has a data sheet that seeds the pivot table. This data sheet is dynamically loaded in the java application through the Apache POI api.
When I open the excel file I must refresh the Pivot table manually to get the data loaded correctly.
Is there any way to refresh the Pivot table with the POI api so I don't have to manually do it?
Best Answer
You can simple activate an option that will refresh the pivot table every time the file is opened.
This Microsoft documentation says :