How to use OFFSET formula when the source file is closed

Hi,

I have an OFFSET formula to get an every nth row in another excel, The links are correct, the formula works, but when I exit out of the source file and update I'm getting a #VALUE! error. When I open it back up, the formula is back and working perfectly. Any idea why this could be? It's in a shared folder, but I have many other formulas on the same page that link to this file and they don't have this problem.

Thank you in advance

Thank you so much for your immediate response,

Please help me how to use index instead of OFFSET in my formula

I will explain what i want is - i have two excel files one is Master list.xls another one is Tool2.xls. I want to copy every 20th cell of Column A from master list to Tool2 Column A. As I said in my previous post i used the following formula.

my formula is : IF(COUNT('[Master list.xlsx]Adults'!$C$2:$C$6266)<=10000,OFFSET('[Master list.xlsx]Adults'!B2,(ROW()-2)*19,0))
this formula i want to put it in another excel file, 'Mater list' is my source file

Thank you

Thank you so much for your reply it is working,

but one small problem, Now I am getting from 20th cell but I want to copy first cell first and then every 20th cell

Thank you

Thank you so much its working