Re-establishing link between VISIO and EXCEL

A

Anirban

I have created a Space Plan by taking the input date from an EXCEL Sheet by
importing it to VISIO.But then by changing some value in EXCEL the VISIO is
automatically takes care of the changes by clicking "Refresh Data" button
under Plan tab.
Now if I need to put the VISIO file and the EXCEL to some other location
then I could see the links between VISIO and EXCEL are breaking.Then if I
click the "Refresh Data" button the VISIO is then importing all the data from
EXCEL to the Unplaced data tab and there is no relation with the already
drawn diagram.
It would be of great help if you could tell me how to recreate the link
between VISIO and EXCEL.
 
A

Al Edlund

I haven't tried this personally, but the link is stored in an xml file which
may be editable. The process uses an office data connection (an .odc file).
al
 

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

Similar Threads

Recreating Link between VISIO and EXCEL. 1
Dealing with the error: unable to filter on excel hc home school 0
Embed the same Excel multiple times 0
Visio 2016 - Single exterior wall with multiple thicknesses 1
Dates In Excel 5
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Programatically reading visio diagram data 3
Opening .vsd file in visioviewer when visio prof and viewer instal 0

Top