can XLOOKUP search in closed workbook?

[Arie Bos]

I have the following formula:

=XLOOKUP($C$7;Customers.xlsx!CustomerData[Name];Customers.xlsx!CustomerData[Address])&""

THis works fine as long as the workbook 'Customers' is open. But when I close that file, the full path is inserted, resulting in #REF!:

=XLOOKUP($C$7;'https://xxxxxxxxx.sharepoint.com/sites/Corporate/Shared Documents/Sales/PO/Customers.xlsx'!CustomerData[Name];'https://xxxxxxxxx.sharepoint.com/sites/Corporate/Shared Documents/Sales/PO/Customers.xlsx'!CustomerData[Address])&""

(Note : xxxxxxxxx replaces company name)
Is there a way to still get the right result?

 

[Fluff]

You cannot use structured references to closed workbooks, you will need use ranges instead.