NamedRanges do not import properly

[no-name-2]

After exporting and importing named ranges they are kind of broken.
For example, the output of "?ThisWorkbook.Names("MyName").RefersTo" should be something like "='Table1'!$A$1", but somehow it tends to be "='Table1'!R1C1", which should be the output of .RefersToR1C1 .
What was originally exported does still have the right "$A$1$ format.

[hilkoc]

This has to do with a particular setting in Excel, but I forgot which one.