Link to External Data is lost after file close

[EuTaletR]

If I insert external data via sheet / link to external data and enter a URL and refresh rate (600), it works properly. But when I save, close and re-open the file, the link is gone. The data from last update is still visible, but the list in edit / link to external files... is suddenly empty again.

I included the directory of the file I’m working on via Tools -> Options -> LibreOffice -> Security -> Category: Macro Security -> Button: Macro Security -> Tab: Trusted Sources -> Category: Trusted File Location and also allowed all connections from trusted sources via Tools -> Options -> LibreOffice Calc -> General -> Category: Updating.

Why is the link to external data still lost after closing the file?

[EuTaletR]

LibreOffice Version: 6.4.6.2 / Build ID: 1:6.4.6~rc2-0ubuntu0.20.04.1 / Ubuntu 20.04 LTS x86_64

[anon73440385]

2 rearks / questions:

• Which file format are you using to store your calc files (ods or any other format)
• (since you are on Ubuntu 20.04): Did you ever fully remove your LibreOffice installation and reinstall? There a many reports about failing initial installations of LibreOffice on Ubuntu 20.04 based systems. Many of them could be solved by the following procedure:

Complete Deinstallation

• dpkg --list | awk '/ii/&&/libreoffice/{print $2}' | sudo xargs apt --yes purge
• sudo apt --yes autoremove
• sudo rm -r /usr/lib/libreoffice/* (may cause an error, if there is no contents - ignore

Fresh Installation of LibreOffice

• sudo apt update --yes
• sudo apt install libreoffice libreoffice-gtk3 libreoffice-help-en-us

[EuTaletR]

I’m glad you ordered your remarks wisely - #1 already solved it. I was saving as .xlsx, changing it to .ods fixed the problem. And spared me the re-install. Thank you!

[EuTaletR]

Problem solved. I was saving as xlsx instead of ods. The latter keeps my links after closing the file.

Credit and thanks to Opaque.