Most of the time I'm building workbooks with formulas referencing to other
workbooks, in order that I have the accurate values, all workbooks linked
should be open at the same time, is this how it really works? is there a
better way of doing this; that is, an option of not opening the other files.