Pivot Table

Topics: Developer Forum
Aug 19, 2008 at 2:42 PM
Edited Aug 19, 2008 at 2:58 PM
How to set range for pivot table programatically.?
I have a template with Pivot table on other sheet but not able to set the range since the data is dynamically populated.
since we wont be knowing how many rows ,we cant set the range in template . can anybody help me on this.......?
How to refresh pivot table data programatically.?
Sep 24, 2010 at 5:38 PM

You need to use OPENXML to acomplish this task