#REF! notification while refering to another worksheet on excel

[koppelingproblemen]

While trying to link 2 worksheets on excel with one another, I keep getting a #REF! output on my cells on worksheet 1 that are refering to the other worksheet (2). This only happens when I close the worksheet which is being referred at (2). What to do about this problem?

Sidenote: when I open worksheet 2 again, the #ref! output disappears and the formula works perfectly fine again, so I don't really understand how this problem occurs(??)

[#2]

You may be using a function that requires the external workbook to be open to calculate.
https://excelribbon.tips.net/T006035_Functions_that_Can_Access_Closed_Workbooks.html