Formula Reference breaks after document is re-opened

[RedStarX]

I’m having an issue with LibreOffice Calc. When I do the following formula and reopen the document, the reference to another sheet gets broken.

example:

vlookup(B4,$db.A$2:D$500,2,0)

When the document is saved as 97/2003/2007, the formula’s range reference to the db sheet gets broken after I reopen the document.

vlookup(B4,$db.#REF$#REF:#REF$#REF,2,0)

I don’t quite understand why the range reference is no longer recognized when the document is re-opened.

I am trying not to use the odt format because there are some documents that I create using MS Excel with features that are lost when saved to odt but are preserved when saved as 97/2003/2007 Office format.

Your input is greatly appreciated.

Thanks in advance.

[karolus]

Hallo

Try to rename the sheet db to some Name which is distinguishable from ColumnDB
and of Course also every other possible Column-name from A to Z; AA to ZZ ; AAA to AMJ

Hope it works.