LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
tim
 
Posts: n/a
Default 2003 update link when Source open

Hi,


I recently migrated to 2003 and when using a file created in 2002 the links
do not update when the Source file is open. First, I opent the destination
workbook, choose not to update links, open the source workbook and make
changes. The changes are not updated in the destination workbook.

If I edit the equation in the destination workbook by deleting the path
('\\server\folder\[filename]sheet'!cellref) up to the filename of the source,
then the values update. Once I close the source, the equation in the
destination changes to a mapped drive type path
('S:\folder\[filename]sheet'!cellref).

Why are the links not updating when the source is open, and why is the path
changing from \\server style to mapped drive style?
 
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
Can you update links between workbooks without them both open? Nicolle K. Excel Discussion (Misc queries) 1 January 7th 05 07:39 PM
XL2003 Destination and Source Open but not updating tim Excel Discussion (Misc queries) 2 December 14th 04 01:29 AM
open saved query in Excel 2003 jaylou Excel Discussion (Misc queries) 1 November 29th 04 06:41 PM
auto update an open excel sheet over network, with mutiple users crumkerr Excel Worksheet Functions 1 November 29th 04 11:47 AM
Open a file in excel from a link in eplorer Dave Peterson Excel Discussion (Misc queries) 0 November 26th 04 01:25 AM


All times are GMT +1. The time now is 03:32 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"