…when you save, close, and reopen such a file, all structured refs will be replaced with refs to ranges.
And how to deal with this? Well, I’m tired of doing stupid work.
Example of table structured reference:
myNamedDatabaseRange[[#This Row],[myFieldName]]
They are only supported in OOXML file format.
Release notes 5.1 Table structured references
tdf#85063 - EDITING: Excel structured references/ comment#26
So, I wrap such a ref in INDIRECT function as a string in order to prevent replacing it with standard notation.
Thanks