Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-29-2012, 03:06 PM
lucas lucas is offline External/Embedded links to excel Windows XP External/Embedded links to excel Office 2007
Novice
External/Embedded links to excel
 
Join Date: Mar 2012
Posts: 2
lucas is on a distinguished road
Default External/Embedded links to excel

I had a question about external links. I have a MS Word document (2007) with external links to several MS Excel files. It grabs a chart from each Excel file.



Now, when I move the Excel files, the charts are no longer accessible and can't update (since the directory for the files have been changed).

Is there a way that Word can automatically update the link directory to these Excel files, or do I have to manually change the directory to each Excel file in MS Word?


Thanks in advance.
Reply With Quote
  #2  
Old 03-30-2012, 05:09 AM
macropod's Avatar
macropod macropod is offline External/Embedded links to excel Windows 7 64bit External/Embedded links to excel Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,697
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Lucas,

Whenever you move the file referred to in a Link, you need to update all the references in all the files that Link to it.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 03-30-2012, 06:35 AM
lucas lucas is offline External/Embedded links to excel Windows XP External/Embedded links to excel Office 2007
Novice
External/Embedded links to excel
 
Join Date: Mar 2012
Posts: 2
lucas is on a distinguished road
Default

macropod,

Thanks for your reply. I thought that was the case, but wasn't completely sure.
Reply With Quote
  #4  
Old 03-30-2012, 01:47 PM
macropod's Avatar
macropod macropod is offline External/Embedded links to excel Windows 7 64bit External/Embedded links to excel Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,697
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

If the Excel objects were inserted in-line, you should be able to see the field codes they use by pressing Alt-F9. You can then use Find/Replace to change the paths (Note the use of '\\' for the path separators instead of '\') and and filenames. When you're done, simply press Alt-F9 again, followed by Ctrl-A, F9 to update the links.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
external, link, word 2007

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
External/Embedded links to excel Convert html links into embedded hyperlinks njcloud Mail Merge 23 02-04-2020 02:00 PM
External/Embedded links to excel word macro that reformats embedded links in a doc EricT Word VBA 7 09-12-2012 04:13 PM
External/Embedded links to excel Embedded links spheon Word 1 06-07-2011 04:11 PM
Preventing word/excel from trying to open external template locations Perhill Office 0 03-02-2011 04:44 AM
External/Embedded links to excel Embedded Excel functionality? markg2 Word 1 01-13-2011 02:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:02 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft