I have a spreadsheet that I have three Vlookups into external spreadsheets.
Two of them work brilliantly, but one takes ages to complete, unless the
file is open.
I have checked and I can't see any reasons why this should be. I have used
findlink.xla and made sure that the links are correct and there are no
duplications.
There are also a number of macro's run that are also very slow unless the
problem spreadsheet is open

If anyone can help or give advise it would be greatly appriciated