OLAP Connection Settings Excel

#1

Hi,

I'm using Cubes through Excel 2003 and I'd like to be able to change
the connection settings. For example: I'd like top change the server
name.
Any ideas how to do that???

Help much appreciated.

Chris

#2

Chris,
I was just trying to do this yesterday and wasn't able to figure out
how or if it's even possible to change connection settings in Excel. I
ended up deleting and recreating it.

#3

Try this for Excel 2003 and AS 2000

Sub ChangeDataSource()

For Each pc In ActiveWorkbook.PivotCaches

pc.Connection = "OLEDB;Provider=MSOLAP.2;Datasource=<ServerName>;I nitial
Catalog=<CatalogName>;Client Cache Size=25; Auto Synch Period=10000"
pc.CommandText = "<CubeName>"
Next pc

End Sub

Urs

Kent wrote:

Quote:

Chris,
I was just trying to do this yesterday and wasn't able to figure out
how or if it's even possible to change connection settings in Excel. I
ended up deleting and recreating it.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

OLAP Connection Settings Excel

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

OLAP Connection Settings Excel - 05-09-2006 , 10:04 AM

Re: OLAP Connection Settings Excel - 05-10-2006 , 10:35 AM

Re: OLAP Connection Settings Excel - 05-16-2006 , 06:33 AM