Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Changing old .odc to new .odc

Status
Not open for further replies.

Recce

Programmer
Aug 28, 2002
425
ZA
Good day.

In our company there are many Cube's in Excel files that have Cubes in them with old OLAP.3 connection strings.

The problem is that currently we use OLAP.4 connection strings when we setup Cubes in an Excel.

Some of the older Cubes are beginning to give problems and need to be moved to OLAP.4 connection strings.

I would like to know, is it possible to change the old connection to a new connection because I have tried to just browse to the new connection file or to just copy the connection string into the definition tab of the properties box but, the Spread Sheet does not save that connection.

The thing is some of the workbooks are so huge and have many Cubes in them along with formatting which I can't expect the users to change.

Could anyone make any suggestions of how I can overcome this problem ?

Regards

[pipe] "We know nothing but, that what we know is not the truth..." - Me
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top