Bug 63395 - Unable Refresh Power Pivot
Summary: Unable Refresh Power Pivot
Alias: None
Product: POI
Classification: Unclassified
Component: SXSSF (show other bugs)
Version: 3.17-FINAL
Hardware: PC All
: P2 blocker (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2019-05-02 06:45 UTC by RatiKanata Pal
Modified: 2019-05-06 17:15 UTC (History)
0 users

Template (113.56 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-05-02 06:45 UTC, RatiKanata Pal
Java File (2.51 KB, text/plain)
2019-05-02 06:45 UTC, RatiKanata Pal

Note You need to log in before you can comment on or make changes to this bug.
Description RatiKanata Pal 2019-05-02 06:45:28 UTC
Created attachment 36557 [details]


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.
Comment 1 RatiKanata Pal 2019-05-02 06:45:53 UTC
Created attachment 36558 [details]
Java File
Comment 2 Greg Woolsey 2019-05-06 17:15:54 UTC
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.