Excel 2003: How to view data link to other sources not available

[AlexandreAmant]

Hi all,

Here is my problem:

I have received an excel sheet that contains links to other sources (other excel sheets - which are lost).
When I open the file in excel, I get a pop-up that asks me whether I want to update the links to other sources or not.
At this stage (before clicking to answer this pop-up), the sheet is already displayed and displays ALL the data I need.
When I click on the popup (and whatever I click), some of the data (the one linked to the lost sheet) is replaced by #REF!.

If Excel is able to display the data when the pop-up is prompted, it means that it has somehow remembered it, so there should be a way to access the entire sheet with the old data.

Can anyone help ?

Thanks !

@lex

 

[SkipVought]

Hi,

With Excel open, Tools > Options: Calculation Tab Change Automatic to MANUAL.

Now open your workbook and select do no update.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[BlueHorizon]

Hi,
Maybe you can examine/fix the link using Edit|Links.
HTH,

Best,
Blue Horizon

 

[AlexandreAmant]

Hi SkipVought,

Thanks a lot, this solved my problem (so obvious I did not even think about it !).

Thanks !

@lex