Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel | |||
Chart disappears when source data cells are hidden | Excel Discussion (Misc queries) | |||
Automatic update of links in destination file when source file mo. | Excel Discussion (Misc queries) |