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.

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.

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.