Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamically Change a Pivot Table's Data Range
I have a workbook with a several pivot tables all based on the data contained
within one sheet of the workbook. Attached to this workbook, i have a macro that will update the data sheet (the data is pulled from an oracle database). Within the same macro, i would like to change the range of data each pivot table is based on because every time the data sheet is updated, more rows of data are pulled then the last time (i.e. the pivot table was based on Range("A1:N50") but should now be based on Range("A1:N75"). However, i cannot seem to figure out how to change this programmatically. Can anybody help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I extend an existing pivot table's range | Excel Discussion (Misc queries) | |||
Can Multiple Range Pivot Table's field button's caption be changed | Excel Discussion (Misc queries) | |||
Changing a pivot table's data range in Excel 2007 | Excel Worksheet Functions | |||
Change Pivot Table's query | Excel Programming | |||
Accessing Pivot Table's Data in VBA | Excel Programming |