Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to change (Excel) source of all linked objects in a word docu.
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.) |
#2
|
|||
|
|||
You should be able to use the Replace command:
Press Alt + F9, to view the field codes Choose EditReplace 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 Wheelwater wrote: 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.) -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
EXCEL Workbook tab format options: change color or font | Excel Discussion (Misc queries) | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel |