Re-establishing link between VISIO and EXCEL

External Since: Apr 13, 2008 Posts: 9

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.

External Since: Feb 23, 2004 Posts: 2282

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

"Anirban" <Anirban DeleteThis @discussions.microsoft.com> wrote in message
news:49DD7DB5-6E61-4BAC-98C5-6A9B483B8720@microsoft.com...
>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.
>