Links
I have a very Large workbook with 30 odd sheets. Everything works well until
I try and do a Vlookup into another workbook(WB). I have checked that there are no links in the 2nd WB if the 2nd WB is open it works fine, but if closed it can take anything upto 10 minutes. How can I Stop this? If I don't update at the start and go to Edit / Edit links and update this lookup still 10 minutes to complete. There are other external links that work fine. and loads of internal vlookups that are fine. |
Links
Edit Edit links Open source
I think that the reason it takes so long is that for each link, Excel opens the source file, reads in the information, then closes it again in the background. So you have to do that once for each link. That's how it feels to me. If you open the source file, all the links will refresh at once. Of course, you will have to close it again manually. But believe me it is faster that way. -- Allllen "Sean" wrote: I have a very Large workbook with 30 odd sheets. Everything works well until I try and do a Vlookup into another workbook(WB). I have checked that there are no links in the 2nd WB if the 2nd WB is open it works fine, but if closed it can take anything upto 10 minutes. How can I Stop this? If I don't update at the start and go to Edit / Edit links and update this lookup still 10 minutes to complete. There are other external links that work fine. and loads of internal vlookups that are fine. |
Links
There is nothing strange about the data being held in the spreadsheets, but I
can't process any macro, or update when opening the file, when other links work well in the background "Allllen" wrote: Edit Edit links Open source I think that the reason it takes so long is that for each link, Excel opens the source file, reads in the information, then closes it again in the background. So you have to do that once for each link. That's how it feels to me. If you open the source file, all the links will refresh at once. Of course, you will have to close it again manually. But believe me it is faster that way. -- Allllen "Sean" wrote: I have a very Large workbook with 30 odd sheets. Everything works well until I try and do a Vlookup into another workbook(WB). I have checked that there are no links in the 2nd WB if the 2nd WB is open it works fine, but if closed it can take anything upto 10 minutes. How can I Stop this? If I don't update at the start and go to Edit / Edit links and update this lookup still 10 minutes to complete. There are other external links that work fine. and loads of internal vlookups that are fine. |
All times are GMT +1. The time now is 07:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com