So I am looking up some figures from another spreadsheet.

When both spreadsheets are open the numbers appear.

But if I close the one that it is looking up from, the next time I open it I get N/A values.

Is there anyway to link the spreadsheets without having to have them both open all the time please?