Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic PivotTable Data Source
Hi,
Is there a way for me to put the datasource,sheet and range information in a cell, then reference the PivotTable to that cell to get the information? I have 3 PivotTables and would like to be able to access between current and historical data without having to go through the manual process of: - Starting the wizard - Click back - Update the datasource - Click OK All datasources are exactly the same, except for the workbook name. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic PivotTable Data Source
Lenardz wrote:
Hi, Is there a way for me to put the datasource,sheet and range information in a cell, then reference the PivotTable to that cell to get the information? I have 3 PivotTables and would like to be able to access between current and historical data without having to go through the manual process of: - Starting the wizard - Click back - Update the datasource - Click OK All datasources are exactly the same, except for the workbook name. Any ideas? Here is one idea, make three pivot tables, each on thier own Worksheet. Then you could select thier tab to switch between them... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Dynamic Data source help | Charts and Charting in Excel | |||
updating pivot tables using dynamic data source | Excel Discussion (Misc queries) | |||
Pivottable - use same source data, and group data differently | Excel Discussion (Misc queries) | |||
Select different source data for a PivotTable | Excel Worksheet Functions | |||
Dynamic references in diagram source data? | Excel Discussion (Misc queries) |