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

S

Suzuki7

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.
 
T

Tushar Mehta

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
 
J

Jon Peltier

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/
_______
 

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

Chart Source Data 5
Update OLE Links in Powerpoitn from Excel 0
How do you link chart source data when you copy the chart? 1
How do I edit replace source data links for a chart? 1
linking workbooks when source data moves 1
Linked Charts Lose Formatting 1
Excel 2007 Chart Data Selection- Arrow Keys Frustration 0
How do I change the source worksheet for 100 charts automatically. 1

Top