Link Updates
 

I have 2 files that are related. The target file has a formula to read the
value in a cell in the source file. If the target file is not open, and I add
rows to the source file the row number doesn't update. Is there any way
around this or is it just supposed to work this way. When both files are open
the row number in the target file does update.
--
Thanks for any help!
Keith