On Nov 7, 4:44*am, "DVAL" wrote:
Please.
I need to pull data from another closed excel file!

Thank you for reading this especially if you are able to help me out on
this.

INDIRECT does NOT work with closed workbooks. Use linking formulas or
a macro to openget dataclose