Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

Bring back ability to change ODC file in Excel

I have an Analysis Services cube that my users connect to from Excel using an ODC file. We use multiple environments (cubes), such as demo, test, and production, each with a separate ODC file for convenience. I want to be able to change the ODC file of a given Excel report so that it references a different environment, but then Excel will "lose" the reference to the new ODC file, embedding the connection information instead.

Please see https://social.msdn.microsoft.com/Forums/sqlserver/en-US/0f78f352-f7aa-4368-a9c9-cd35030955fd/changing-odc-file-in-excel for more information.

5 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

John Keller shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base