How can I reference an external workbook with look-up tables in it from
another, yet keep the look-up table workbook closed

I have formual for calculation in one workbook, looking up values in second.
Works fine when second open but not when it's shut.

Whole point of excersise is to keep constants listed in look-up tables
hidden as they are commercially sensitive.