ExcelBanter - OLAP Pivot Table

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - OLAP Pivot Table (https://www.excelbanter.com/excel-discussion-misc-queries/263294-olap-pivot-table.html)

Carissa

OLAP Pivot Table

I have several pivot tables connected to an OLAP cube. However, the server
hosting our cube has been migrated to a new location. So I need to re-direct
my pivot tables to pull source data from the correct location. How would I
do this?

Roger Govier[_8_]

OLAP Pivot Table

Hi Carissa

Take a look at Ron Coderre's addin
http://www.contextures.com/xlPivotPlayPLUS01.html

--
Regards
Roger Govier

Carissa wrote:
I have several pivot tables connected to an OLAP cube. However, the server
hosting our cube has been migrated to a new location. So I need to re-direct
my pivot tables to pull source data from the correct location. How would I
do this?

All times are GMT +1. The time now is 05:56 AM.