Linked Spreadsheets in Excel 2003
David,
Thanks for the quick response. However, I need to follow up on this. I
don't understand. If the linked to spreadsheet is already open, then why
would Excel try to open it again to perform the update? I guess the
confusion is inthe fact that if the linked to spreadsheet is already open, I
am not getting the option to update the spreadsheet that contains the links
when I open it, I only get the update option if the linked to speradsheet is
closed when I open the spreadsheet that contains the links themselves.
Thanks again for the help. :)
"David Benson" wrote:
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.
|