Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Suzuki7
 
Posts: n/a
Default 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.
  #2   Report Post  
Tushar Mehta
 
Posts: n/a
Default

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.

  #3   Report Post  
Jon Peltier
 
Posts: n/a
Default

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with data not getting plotted Scott Ehrlich Excel Discussion (Misc queries) 2 January 25th 05 06:17 AM
Help with data not getting plotted Scott Ehrlich Charts and Charting in Excel 1 January 23rd 05 06:15 PM
Excel 97 chart opened in Excel 2003 - Source Data problem DHunt Charts and Charting in Excel 0 December 6th 04 09:05 PM
Chart disappears when source data cells are hidden Disappearing charts Excel Discussion (Misc queries) 2 December 5th 04 04:24 AM
Automatic update of links in destination file when source file mo. Brucgil Excel Discussion (Misc queries) 0 December 2nd 04 05:07 PM


All times are GMT +1. The time now is 03:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"