excel link doesnt update when source changes

[Steve Paul]

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
source file,then insert another row, the reference in the destination
worksheet doesn't change. Is this normal, or is there some setting in Excel
I need to change to alter this behaviour,

thanks,

 

[Beth Melton]

If the destination file is not open when you modify the source then
due to a security patch that prevents various links from automatically
updating you may need to go to Edit/Links and update the links
manually.

If this isn't the case then you may want to ask your question in one
of the Excel newsgroups since that's where the Excel experts tend to
hang out.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

 

[Steve Paul]

thanks - can you point me to an excel newsgroup ?

 

[bxb7668]

Try microsoft.public.excel.links

thanks - can you point me to an excel newsgroup ?