| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing Data Source on Multiple Pivot Tables at once
I have a worksheet with 70 small, simple pivot tables all referencing an OLAP
cube. I need to change the OLAP cube data source each month and do not want to go to each pivot table and update the data source. How can I set up something to allow me to change the data source once for all the pivot tables? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing Data Source on Multiple Pivot Tables at once
Hi
Download a copy of Ron Coderre's PivotPlay Plus add in from Debra Dalgleish's site http://contextures.com/PivotPlayPLUS.zip -- Regards Roger Govier "marjhan" wrote in message ... I have a worksheet with 70 small, simple pivot tables all referencing an OLAP cube. I need to change the OLAP cube data source each month and do not want to go to each pivot table and update the data source. How can I set up something to allow me to change the data source once for all the pivot tables? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Source in Pivot Tables | Charts and Charting in Excel | |||
| Multiple pivot tables, based on same source data tab; disable refreshon 1st tab? | Excel Worksheet Functions | |||
| Multiple Pivot tables using the same source data | Excel Discussion (Misc queries) | |||
| Getting source data range in multiple pivot tables | Excel Discussion (Misc queries) | |||
| Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
Linear Mode
