Link path not updating when renamed
 

We have a process by which we open a (multiple sheet) Excel workbook, then
open a Word document with links to the Excel file. We then rename the Excel
file (to a different path & filename (everything is on the same machine)) and
check that the Word links have updated correctly. This system works perfectly
in Office 95.

Since updating to Office 2003, however, we only have the links to the
CURRENTLY OPEN Excel sheet which update to the new path and filename. All
other links still point to the original (pre-renamed) path & filename.
Why do the other sheets not update??

Any help appreciated