ExcelBanter - Change Olap datasource

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Change Olap datasource (https://www.excelbanter.com/excel-programming/330674-change-olap-datasource.html)

Henrik Skak Pedersen

Change Olap datasource

Hi,

I would like to prompt the user for Olap server name everytime I open a
specific excel document and then I want to apply that name to all
PivotTables.

How is that possible?

Regards

Henrik Skak Pedersen.

All times are GMT +1. The time now is 01:52 AM.