How to change a database link?

[hubo]

I've crated a visio drawing by first generating master shapes from an Excel
"database". Using the Database wizard I got all shapes generated from the
Excel document. After that I manually arranged the shapes as I wanted to and
made connections. Everything works fine so far, I can change in Visio and the
database is updated or make changes in Excel and Visio is updated.

Now to the problem. I have several very similar drawings to maintain so I
made a copy of the Visio document, and of the Excel document, and renamed
them. My intention was to change the database link in Visio to point to the
new Excel document. But all my tries fail:-( The Visio keeps it database link
to the original Excel document. I have tried the Database wizard in numerous
ways, the "Link to database..." and even changed "Select database record" for
every single shape.

Can anyone help me?

Best Regards /Hugo

 

[Bernhard Marx]

Hello Hubo,

did you get an solution for this problem so far? I have even the same
problem. I'm working with shapes connected to MSSQL-Server. But the Server
für developing differs from the productive system.

Thx for your help

Bernhard