loosing link to external data (Excel table)

J

Joel

I am using an external data link to an Excel table to update a large
organization chart in Vision 2007. Unfortunately the said link gets lost
every time I close the Visio file and I have to create it again and again.

Although I am not sure, I suspect this might be caused by Visio changing the
data link to the Excel table from an "absolute" to a "relative" address when
saving the file, as done by other Microsoft applications like Word, Excel,
PowerPoint etc.

While I can explicitly instruct these other applications not to switch from
absolute to relative address when saving (uncheck the box under
'Tools/Options/General/Web Options/Files/Update links on save') I do not find
a corresponding option in Visio 2007. Can anyone help ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top