VLOOKUP change when change the file folder location

[Lenci193]

I have 3 file Excel.

home/main/Testing/TestingFile_1.xlsx
home/main/Testing/TestingFile_2.xlsx
home/main/Testing/TestingFile_3.xlsx

In the TestingFile_2.xlsx, I using VLOOKUP to get a data from File1:

=VLOOKUP("TESTING_001",'TestingFile_1.xlsx'#$TestCase.$A$6:$E$500,3,0)

In the first time. when I pressed Enter button, the data is correct and Input line is:

=VLOOKUP("TESTING_001",''file:///home/username/main/Testing/TestingFile_1.xlsx'#$TestCase.$A$6:$E$500,3,0)

Then when I coppy Testing folder to other location, it changed to:

=VLOOKUP("TESTING_001",[33]testcase!$a$6:$E$500,3,0)

Does anyone has issue it before, and how to fix that?

[erAck]

Which LO version even (Help → About, use copy-button and paste here)? Works fine for me, 24.2.2.0.0+
I assume you closed the document and reopened it from the new location.

Please edit your original question to provide further details. Thanks.