Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Changing old .odc to new .odc

Changing old .odc to new .odc

Changing old .odc to new .odc

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 ?


pipe "We know nothing but, that what we know is not the truth..." - Me

RE: Changing old .odc to new .odc

Did you try to change the ODC (My Documents\My Data Sources) files?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close