ExcelBanter - Changing Data Source on Multiple Pivot Tables at once

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Changing Data Source on Multiple Pivot Tables at once (https://www.excelbanter.com/excel-worksheet-functions/207438-changing-data-source-multiple-pivot-tables-once.html)

marjhan

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?

Roger Govier[_3_]

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?

All times are GMT +1. The time now is 02:47 PM.