Let me preface this by stating that I am using a rather old version of LibreOffice 18.104.22.168 as that is what is current With RHEL/CentOS 7. I have a newer version on a LinuxMint virtual machine and will try that. However, due to the location of files and other programs on my workstation that presents some other challenges. Here is the issue:
I perform some financial analysis which dumps a row of summary data to an Excel format file. One row of data from A1 to H1. I have linked my Calc spreadsheet to that data with links such as:
This works great and brings in the data I need. (Yes, there are two “data” directories in the path.) However, after saving the file and reloading it I get the dialog to update links. I press yes and get an error message to the effect:
“The following external file could not be loaded. Data linked from this file did not get updated.
When I examine the cells with my linked data I see that the path has been shortened.
One final tidbit… I created a new calc spreadsheet, linked ONE call, saved the file and reloaded. The link was intact. I then copied the cell with the link across the row so as to read all of the data from the source Excel file. It worked great. When I saved and reloaded the file with multiple cells linked I received the error described above.
Yes, I am saving my Calc spreadsheet as .ods (I have read issues related to saving the linkING spreadsheet in Excel format.)