Hi Steve,
I've never had to write a formula that refers to other workbooks. I
know it is done but I'm not aware of the pitfalls. I can vaguely recall
reading that some functions require the referred to workbooks be open,
but that's all I know about that.
Hopefully splitting up the workbook won't be necessary.

Ken Johnson