How to use named ranges in other files?

callous · January 25, 2025, 6:20am

I have a named ranges on file A and I need to use them in file B.

inventory = $Inv.A2:K1001
inv_cols = $Inv.A1:K1
...etc

When I need to use them in the same file I can just call inventory/inv_cols...etc but in another file, do I need to prefix every named ranges in formulas with file:///...?? Like this?

=LET(col, (file:///...inv_cols="Product")*(file:///...inv_cols="Price")*(file:///...inv_cols="Id"), formula...)

Lupp · January 25, 2025, 12:05pm

I no longer use “external named ranges”, but my first (clumsy) bug report 12 years ago was about them. The bloated discussion in the bug tracker back then led to nothing, and the thread contains now “broken links”. But comment #12 might give some insight into the problem.
" 61743 – Wrongly Absolute Path Referencing to named Ranges Across Documents "