Can I force Excel to fully define formula links?

e.g. I want it to define a Cell, which is the product to two others as:
=currentSheet!A42*currentSheet!B52
instead of just:
=A42*B52

Trouble is I don't know how the worksheet is being created, so I need an
option to tell Excel what to do.

Thanks,
Peter