Skip to main content linkedinfacebooktwittermenuarrow-up
Contact Us

New to GemBox Support Center? Register for an account

Need a password reminder?

Refreshing pivottable's datasource - Community / GemBox.Spreadsheet Feature Request - GemBox Support Center

New GemBox.Spreadsheet Feature Request
Refreshing pivottabl... Community
8

Refreshing pivottable's datasource Completed

I using an excel template with pivot table (crosstab report).

In this example, https://www.gemboxsoftware.com/spreadsheet/examples/c-sharp-vb-net-create-excel-pivot-tables/114, I can not find any methods to perform an action like refreshing data of pivot table (I used named range like data source). I'm looking for an feature can be support in this case. 

Official response

Mario - GemBox

Hi, This feature request has been implemented and is available in the latest versions of GemBox.Spreadsheet. Regards, Mario

Comments (2)

Paolo
Has this feature been implemented? I have same problem to refresh PivotTables already in an Excel file I'm feeding with data using GemBox. After finished to write new data I need to refresh PivotTables content.
Mario - GemBox
Hi, Unfortunately no, this feature is still missing. GemBox.Spreadsheet currently does not provide the functionality to calculate the actual data of the Pivot Table. Microsoft Excel application will refresh the Pivot Table when the output Excel file is opened. Regards, Mario
New GemBox.Spreadsheet Feature Request
Refreshing pivottabl... Community
Author
Mai Tri Thien
Creation date
Apr 29, 2014
Last update
Dec 7, 2021
Publish date
Apr 29, 2014