Hi,
I have an Excel file that has a Pivot table with multiple filters in it. When the file is opened one of the Filters is set. I can get a reference to the PivotTable and to the PivotFilter class.
If I set the FilterString to be the value that I want it to be, how do I get the data in the table to refresh programmatically?
If I Run pivotTable.CalculateData() then nothing happens.
Is it possible to get the data in the PivotTable to refresh in memory?
Thanks
Dominic