View Single Post
 
Old 01-04-2016, 04:03 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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 you open the document and press Alt-F9, your links will most likely convert to something like:
{ LINK Excel.Sheet.8 "C:\\Users\\Firooz\\Documents\\Workbook.xls" "Sheet1!R1C1:R10C10" \a \f 5 \h }
You can then use Find/Replace to change whatever parts of the path & filename have changed. Note the use of \\ as the path separator. When you're done, press Alt-F9 again to restore the linked display, then Ctrl-A, F9 to update the links.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote