How do I automatically update chart source data links for moved fi
 

Am i able to autoupdate chart source data links, after moving the original
source file, from one folder to another.

Example

Original destination
G:\Customer\Data1

New destination
G:\Customer\Data2

The link still looks to 'Data1', but the file no longer exists in there.

I have many links and don't wish to update manually, if there is an easier
way.

With the later versions of XL, you can select Edit | Links... and in
the resulting dialog box update an old link to point to a new source.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Am i able to autoupdate chart source data links, after moving the original
source file, from one folder to another.

Example

Original destination
G:\Customer\Data1

New destination
G:\Customer\Data2

The link still looks to 'Data1', but the file no longer exists in there.

I have many links and don't wish to update manually, if there is an easier
way.

With the later versions of XL,

This has worked since at least Excel 97.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Tushar Mehta wrote:

With the later versions of XL, you can select Edit | Links... and in
the resulting dialog box update an old link to point to a new source.