G
Guest
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
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