Excel File with Numerous links takes a long time to open

[Guest]

I have an excel file with a large number of external data links. I want to
be able to open the file without it automatically going out to attempt to
update all the data. In Excel 2003, it would prompt me if I wanted to update
or not. Now it seems to do it automatically which means that this file can
take up to five minutes to load.

Any way to turn this off?

 

[Jim Rech]

In Excel 2003, it would prompt me...

So what are you using these days? Regardless of the version these is an
option to Ask to Update Automatic Links. Make sure it's selected.

--
Jim
|I have an excel file with a large number of external data links. I want to
| be able to open the file without it automatically going out to attempt to
| update all the data. In Excel 2003, it would prompt me if I wanted to
update
| or not. Now it seems to do it automatically which means that this file
can
| take up to five minutes to load.
|
| Any way to turn this off?

 

[Guest]

Sorry, it's Excel 2007.

So what are you using these days? Regardless of the version these is an
option to Ask to Update Automatic Links. Make sure it's selected.

--
Jim
|I have an excel file with a large number of external data links. I want to
| be able to open the file without it automatically going out to attempt to
| update all the data. In Excel 2003, it would prompt me if I wanted to
update
| or not. Now it seems to do it automatically which means that this file
can
| take up to five minutes to load.
|
| Any way to turn this off?