Hi, all

I have this specific formula which links the data from external Excel files. But I noticed whenever I close the source files, the result will show #VALUE and data will only be shown if I open the source files.

How can I set my files in order for the main file to work without opening the source files? Does it relate to path of files?

My formula is as below for example:
=OFFSET('[VN.xlsb]Raw Data 2018_PhuMy2'!$R$38,0,ROW()-9)

Thanks in advance. Appreciate your assistance.