View Single Post
  #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