John,

If spreadsheet B is open when spreadsheet A is opened, Excel automatically
updates the links. However, if spreadsheet B is closed, then Excel has to
open it in order to update the links (B doesn't remain open for use after
the updates are processed, but it still has to be opened). This can be a
fairly lengthy process if the spreadsheets are large, so Excel gives you the
option of not updating.


-- David

"john mcmichael" wrote in message
...
I have 2 spreadsheets in Excel 2003. Spreadsheet A has links to data in
spreadsheet B. If spreadsheet B is closed when I open Spreadheet A, I am
asked if the links should be updated. If Spreadsheet B is open when I
open
spreadheet A, I am not asked if the links should be updated.

Why am I only asked if updates should be made if the linked to spreadheet
is
closed?

Thanks in advance for clearing up that which is cloudy for me.
Have a great day.