Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ausrobbo
 
Posts: n/a
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HELP! How do you--> Lock a set of rows but also link worksheets to FRUSTRATED Excel Discussion (Misc queries) 6 December 29th 04 10:05 PM
Past Link then copy Hal LEGERE-Steam Guy Excel Discussion (Misc queries) 3 December 23rd 04 02:58 PM
XL2003 Destination and Source Open but not updating tim Excel Discussion (Misc queries) 2 December 14th 04 01:29 AM
How do link to a remote worksheet using the path value in a field? Michael T. Links and Linking in Excel 3 December 11th 04 08:45 AM
How do link to a remote field but use the path from a stored field Michael T. Excel Discussion (Misc queries) 1 December 10th 04 12:18 AM


All times are GMT +1. The time now is 10:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"