Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-19-2016, 08:22 AM
JDHeisenberg JDHeisenberg is offline Update source for multiple links to excel document Windows 10 Update source for multiple links to excel document Office 2013
Novice
Update source for multiple links to excel document
 
Join Date: Aug 2016
Posts: 3
JDHeisenberg is on a distinguished road
Default Update source for multiple links to excel document


I have a word document with 20+ links to an excel document. When I go to produce a new report, I copy my word and excel template file and rename. I now need to update the link source to recognize my new excel sheet.

As of now, I have to update the source for each individual 20+ links, is there a way to automate this process? I dabbled in excel macros a few years ago but do not know beyond the basics.

I tried highlighting all the links in the link manager screen then updating the source. This just automatically opens and has me select the source location 20 times.

Thanks
Reply With Quote
  #2  
Old 08-19-2016, 04:23 PM
macropod's Avatar
macropod macropod is offline Update source for multiple links to excel document Windows 7 64bit Update source for multiple links to excel document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

You could use Find/Replace to change the paths:

Simply press Alt-F9 to expose the field codes in the document, then use Find/Replace to replace the old path/filename with the new one. Note that you'll need to use double backslashes as the separators. Once you've done the Find/Replace, Alt-F9 again the toggle the field code display, then press Ctrl-A, F9 to refresh the links.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Update source for multiple links to excel document How to update source excel file with changes made to insserted excel file in OneNote winwell OneNote 1 11-03-2015 12:19 PM
Update source for multiple links to excel document Changing Field Links in a Word Document from one excel file to another Fed77 Word VBA 9 07-08-2015 02:24 AM
Update source for multiple links to excel document How do you update your source docs from a master document? Joyce Word 3 07-12-2013 08:54 AM
no automatic update from external source file Intruder Excel 1 11-08-2012 08:03 PM
Link and change source for multiple tabs from excel to powerpoint excel3 PowerPoint 1 01-19-2012 02:01 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:10 PM.


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