We have a document with lots of linked objects to an Excel-file (Graphs and
lists). This document shall be reused once every year and the Excel-file and
the Word-document is copied to a new folder with the present year as
foldername. The problem is that the new Word-document still links to the old
Excel-file. How can I update the filepath on a linked Excel-object in Word?

(At the moment the Excel-file and Word-file are placed in two separate
folder beneath the year-folder but thats not necessary if it helps solving
the problem. Also the Excel-file is named with the present year in the
filename - thats not necessary either but its better if its possible.)

Here is how the folders and files are set up

Project
2004
Presentation
Worddocument.doc (containing links to Excelspread 2004.xls)
Data
Excelspread 2004.xls
2005 (copied from 2004)
Presentation
Worddocument.doc (must be updated to link to Excelspread 2005.xls)
Data
Excelspread 2005.xls (the 2004 file renamed)



Thanks
/Henrik

I found it. (Under Edit - Links... in the menu)


"Henrik" skrev:


We have a document with lots of linked objects to an Excel-file (Graphs and
lists). This document shall be reused once every year and the Excel-file and
the Word-document is copied to a new folder with the present year as
foldername. The problem is that the new Word-document still links to the old
Excel-file. How can I update the filepath on a linked Excel-object in Word?

(At the moment the Excel-file and Word-file are placed in two separate
folder beneath the year-folder but thats not necessary if it helps solving
the problem. Also the Excel-file is named with the present year in the
filename - thats not necessary either but its better if its possible.)

Here is how the folders and files are set up

Project
2004
Presentation
Worddocument.doc (containing links to Excelspread 2004.xls)
Data
Excelspread 2004.xls
2005 (copied from 2004)
Presentation
Worddocument.doc (must be updated to link to Excelspread 2005.xls)
Data
Excelspread 2005.xls (the 2004 file renamed)



Thanks
/Henrik

If the links really are links, then ALT+F9 will display the content of the
link thus:

{ LINK Excel.Sheet.8 "D:\\My Documents\\Word documents\\Filename.xls" "" \a
\f 0 \p }
or
{ LINK Excel.Sheet.8 "D:/My Documents/Word documents/Filename.xls" "" \a \f
0 \p }

While this is displayed, you can use replace to replace the path and
filename shown with the new path and filename. Ensure the Excel sheet is
where it is supposed to be, then toggle back and update the fields. Finally
save the document with the new name.


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Henrik wrote:
We have a document with lots of linked objects to an Excel-file
(Graphs and lists). This document shall be reused once every year and
the Excel-file and the Word-document is copied to a new folder with
the present year as foldername. The problem is that the new
Word-document still links to the old Excel-file. How can I update the
filepath on a linked Excel-object in Word?

(At the moment the Excel-file and Word-file are placed in two separate
folder beneath the year-folder but thats not necessary if it helps
solving the problem. Also the Excel-file is named with the present
year in the filename - thats not necessary either but its better if
its possible.)

Here is how the folders and files are set up

Project
2004
Presentation
Worddocument.doc (containing links to Excelspread 2004.xls)
Data
Excelspread 2004.xls
2005 (copied from 2004)
Presentation
Worddocument.doc (must be updated to link to Excelspread
2005.xls) Data
Excelspread 2005.xls (the 2004 file renamed)



Thanks
/Henrik