How do I prevent external file links to get changed into a number in brackets after having saved

asked 2017-06-08 07:49:03 +0200

OliTree gravatar image

Within file "x", I made links ('file:///filepath/filename'#sheet.range) with formulas and calculations to search within file "y".

In some windows, I also made links within data validation to cover a cell range from the other file.

All the links and formulas work correctly after having written them.

But after saving, closing, opening, the link names get reduced to the same number in brackets, and no longer work.

edit retag flag offensive close merge delete


In what format (e.g. .ods, .xls, .xlsx etc) are you saving the file(s)

robleyd gravatar imagerobleyd ( 2017-06-08 10:38:11 +0200 )edit

Assuming .xlsx What version of LibreOffice?

erAck gravatar imageerAck ( 2017-06-08 21:46:37 +0200 )edit

I save in .xlsx

But what's interesting is that is some other files, all in .xlsx, these links have worked, while in others they don't. I've been trying to figure out what I did different but haven't found a difference.

OliTree gravatar imageOliTree ( 2017-06-08 22:18:46 +0200 )edit

On version

OliTree gravatar imageOliTree ( 2017-06-08 22:19:44 +0200 )edit