With bugfix of #96915 was added the option to link named expressions with local scope in other sheets of the same file. Nice if it was implemented the ability to link named expressions with local scope in other files.
Release notes 5.2 https://wiki.documentfoundation.org/ReleaseNotes/5.2#Using_named_expressions_and_ranges_with_sheet-local_scope_on_other_sheets
Sounds useful -> NEW
Still Version: 7.1.3.2 (x64) / LibreOffice Community Build ID: 47f78053abe362b9384784d31a6e56f8511eb1c1 CPU threads: 4; OS: Windows 10.0 Build 21376; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL