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.