I have a spreadsheet that has a number of rows (@1500) and a number of
columns @70) most of the cells contain multiple VLOOKUPS (they have to look
up to 6 different workbooks). As you can imagine this is taking a while to
calculate.

I was thinking about turning off the autocalc have all the associated
workbooks open, update the links then close. But I'm not sure if when the
spreadsheet is allowed to calculate, if the end results will be correct.

Anyone have any thoughts on this?

Thanks,
Chris