Hello,
Good Day!

I am using this excel formula within the same sheet and working perfectly.

=FILTER(Table1[#All],Table1[[#All],[NAMES]]='AUGUST - 2024'!C15)


But I want to use this Filter formula to take data from other excel file ( not the same). Where should I put the path of the excel file so that I could take data using other file.

Thanks