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 <[email protected]>,
[email protected] 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.
>