I have a spreadsheet that uses extensively OFFSET(INDIRECT(cell),0,0,1,1))
where cell refers to a cell containing a XLS name because the filename and
path change monthly. When I open the main file all my cells containing the
above formula show "#REF" until the spreadsheets it's referring to are open.
I have a macro that automatically opens all the referring spreadsheets ~12
files. Shouldn't Excel take a snapshot of the data once I save the main file?
I want to be able to view the data as it is without opening the 12 files it's
referring to. Is it possible? Any other approach is welcome.

Thanks.