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