Don't know for sure if this will answer your questions, but it can't hurt.

http://www.dummies.com/WileyCDA/Dumm...FFICESOFT.html

"mepetey" wrote:

Can anybody help with a general question.

I have multiple Worksheets that refer to other, subsidiary sheets. Why is
it that some times the subsidiary sheets have to be open for the references
to work, but in other examples they do not?

Most baffled!