Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel File with Numerous links takes a long time to open
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel File with Numerous links takes a long time to open
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File takes too long to open | Excel Discussion (Misc queries) | |||
Excel file with hyperlinks takes a long time to open over the network | Links and Linking in Excel | |||
Excel Help takes a very long time to load | Excel Discussion (Misc queries) | |||
Save takes long time | Excel Discussion (Misc queries) | |||
Excel file takes a long time to save | Excel Discussion (Misc queries) |