Workbook Linking References

[axemonk]

Linking workbooks like this is such bad practice (in my opinion) that I haven't run into it until now when attempting to make a workbook link to test the way Excel tracks workbook links. The Excel example photos shown below are ordered from least escaped to most escaped; note the [( in #⁠3.

This is low priority, but putting it here now so as to not forget. Will also need to evaluate how this interacts with LibreOffice Calc and its unique way of referencing sheets.

Using Libre sheet ref style in LOCalc (wth is that # doing there):
='file:///C:/Users/XXXX/OneDrive/GitHub Stuff/LibreSheetNames_v3.ods'#$Sheet1.A1

Using Excel sheet ref style in LOCalc:
=['file:///C:/Users/XXXX/OneDrive/GitHub Stuff/LibreSheetNames_v3.ods']Sheet1!A1

This is moot for google sheets as far as I know. They use IMPORTRANGE(link_to_first_spreadsheet, tab!column(s)) to link two workbooks.

The workbook linking references look like they do in the below photos when both workbooks are open. When the file being referenced is closed, the filename enclosed with [] gets prepended with a URL or path to the file, then the URL/path&Filename&Sheetname string gets wrapped with '.