| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to maintain dynamic data range for Excel PivotTable
Alright so that seems like a good method but here is something else i hadn't
thought about. What if I used an external data connection? Each pivot table is then based on that data connection to the source worksheet and refreshes automatically (without code) upon opening? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to maintain a set range of cells when dragging a formula (e.gmonthlyannual data) | Excel Discussion (Misc queries) | |||
| dynamic data range in pivot tables excel 2007 | Excel Discussion (Misc queries) | |||
| Dynamic PivotTable Data Source | Excel Discussion (Misc queries) | |||
| Dynamic Table Should Always Maintain Borders When Data Is Updated | Excel Discussion (Misc queries) | |||
| PivotTable Dynamic Range | Excel Programming | |||
Hybrid Mode
