references to data sheets
 

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!