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? |
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? |
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? |
All times are GMT +1. The time now is 05:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com