View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Brian Brian is offline
external usenet poster
 
Posts: 683
Default Excel File with Numerous links takes a long time to open

Sorry, it's Excel 2007.

"Jim Rech" wrote:

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
"Brian" wrote in message
...
|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?