I have a number of indirect formulas that read other workbooks. When these other workbooks are opened using a hyperlink the indirect formula seems to show a ref error?

When opening them normally the indirect formula works fine!?

Very strange.. can anybody help?

Thanks

Chris