Created attachment 36557 [details] Template Hi, In my application I am using Power Pivot .I am reading the excel and putting data in the table .I am able to do that.But while opening the File pivot gets refreshed and taking lot of time . I want to refresh the table before saving.
Created attachment 36558 [details] Java File
This isn't really a bug report or feature request. As it is a usage question, it is better suited for the POI users mailing list. That said, there is no code in POI to refresh a pivot table. You would need to do that yourself in your code, making use of the POI formula evaluation framework to manually recalculate the pivot table and update the appropriate pivot table data structures. You are better off letting Excel do that, and perhaps refining the dataset and formulas to improve performance.