It seems to me the best solution might be to combine the workbooks referenced by your LOOKUP formulae into the workbook containing those formulae. That way, you don't have to worry about which workbooks are open. Furthermore, this approach requires no macros and, subject to worksheet size limitations with older Excel versions, will work with any version of Excel.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]