Once we moved to SSAS 2005. We use Excel 2002 as Clinet.
I know I have to install
a) Microsoft Core XML Services (MSXML) 6.0
b) Microsoft SQL Server 2005 Analysis Service 9.0 OLE DB Provider
on clinets box

How can I change my ole DB connection in Excel files.

We use to use Excel Macro and update
ActiveCell.PivotTable.PivotCache.Connection
information when moving from one server to other but I don't see ole DB
version in this connection string. what should I do?

Thank you - Ashok

This is my guess but please confirm if you know because I don't have 2005
ready to test. Excel Macro

With ActiveCell.PivotTable.PivotCache
Response = MsgBox("Current Connection: " & .Connection)
.Connection = Replace(.Connection, "MSOLAP.2", "MSOLAP.3")
Response = MsgBox("New Connection: " & .Connection)
End With


"Ashok" wrote: