Referencing a closed Sheet in Excel 2013

Hello. I have an index match formula which references another workbook, but if I have the sheet with the table in closed Excel gives me an error. Here's the full formula:

=IFERROR(INDEX('X:\Folder1\subfolder\child subfolder\Notes Sheet.xlsx'!UKNotes[Note],MATCH(E10,'X:\Folder1\subfolder\child subfolder\Notes Sheet.xlsx'!UKNotes[Date],0)),"")

I have used the full URL path but still get an error when I close the spreadsheet with the original data in. Is it possible to set it up so when someone else opens the main sheet they don't have to open up the referenced sheet as well?

Thanks in advance

Ah, I think it might be. I will try changing from table referencing to absolute referencing and see if that makes a difference. Pretty annoying if Excel doesn't support something like this though.

Thanks for the heads up.