How to change (Excel) source of all linked objects in a word docu.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

nIn a MS Word document with linked objects, is there a quick way to change
all linked objects (over 50) from one source spreadsheet to a differnet
source spreadsheet? (Too slow to do one at a time.)
 
You should be able to use the Replace command:

Press Alt + F9, to view the field codes
Choose Edit>Replace
In Find What, type the old file name
In Replace With, type the new file name
Click Replace All
Confirm the replacement
Close the Replace dialog box
Press Alt +F9 to hide the field codes
Press Ctrl + A, to select All
Press F9, to update the selected links
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking problems in Excel 2007 2
Links error when insert line/row to source workbook 1
Why is Paste Link not available when I Paste Special 0
Word2003 changing multiple linked source files at once 1
Linking an Excel 2003 document copied to a Word 2003 document 7
PowerPoint Change/update links to new source (PPT with charts & objects linked to Excel) 1
When linked objects update in Word,it keeps changing the spacing? 1
Update Excel from Word 6

Back
Top