Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table groups Refresh
I have written a plugin for Excel 2003 using exposed APIs in VB.NET and have
following porblems. Please help me out. The major function of the plugin is to fetch data from a web serivce and draw Pivot Table, charts for the representation of the data. The problem is that when I refresh the already drawn pivot table for a changed CSV file the data area of the pivot table is updated for the newly populated data in the CSV but the groups made for the fields in rows or columns sections are not refreshed. These groups can be seen by using the drop downs for the row and column fields in the pivot table. I want to find a way to refresh these drop downs on the refresh of the pivot table. I am using Execl.PivotTable's refresh method to trigger the refresh operation after retrieving the new data and creating a new CSV file. Please help me out in this regard. Waiting for your reply. Usman Qadri |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
refresh a new worsheet on pivot table refresh | Excel Worksheet Functions | |||
Pivot Table Groups | Excel Worksheet Functions | |||
Timing of automatic query refresh and macro pivot table refresh | Excel Programming | |||
Pivot Table REFRESH Flaw -- Saves Old Data in Selection Area AFTER REFRESH | Excel Programming |