LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.setup
Steve Paul
 
Posts: n/a
Default excel link updating between 2 workbooks

Hello,

In excel 2003 I have a spreadsheet with a cell (A1) that links to a cell in
another workbook (B3). if the source & destination files are both opened and
I insert a row in the source file, the reference in the destination sheet
automatically changes to recognize the cell change. However, if I save the
destination file,then insert another row in the source file, the reference
in the destination worksheet doesn't change. Is this normal behavour, or is
there some setting in Excel I can change to alter this behaviour, (I know I
can use cell naming)

thanks,

--
Steve Paul
 
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
From several workbooks onto one excel worksheet steve Excel Discussion (Misc queries) 6 December 1st 05 08:03 AM
suddenly my excel workbooks are "shared workbooks" Maggie's mom Excel Discussion (Misc queries) 1 August 28th 05 09:20 PM
want to link excel doc. to pdf. jtrushin Excel Discussion (Misc queries) 1 June 2nd 05 07:44 PM
How do I show more workbooks in the Excel taskpane? Wideejay Excel Discussion (Misc queries) 1 April 28th 05 06:54 AM
Link path not updating when renamed Ausrobbo Excel Discussion (Misc queries) 0 January 17th 05 09:21 AM


All times are GMT +1. The time now is 10:29 PM.

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"