Link to External Data is lost after file close

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?

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

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

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!

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

Credit and thanks to Opaque.