I have a Calc .ods-workbook that I use about once a week. Since about two weeks ago I get a pop-up that asks whether I want to update links in the workbook. It turns out I now have a few unbreakable, non-existing links in my sheet. Help is greatly appreciated. Here are the specifics:
- When I open the workbook I get the message: “This file contains links to other files. Should they be updated?” If I press No, the dialog disappears. If i press Yes I get the message: “The following external file could not be loaded. Data linked from this file did not get updated.”
- I go to Edit > Links and notice that two non-existing links are suddenly present in the workbook: file:///home/stijn/S and file:///home/stijn/L. I have not conciously made this links, they just appeared. The flies mentioned in the links do not and have (probably) never existed. Quite frankly, they are not even complete file paths.
- When I close the workbook and re-open I get the same message every single time.
Solutions I have tried that did not work
I Googled for solutions and found quite a few on how to find and break links, but none work for me:
- If I use Modify or Break link from the Edit > Links menu, the same links will just be magically there after saving and re-opening the file.
- If I try to use Find or Navigator to find where the file paths are linked, I can not find them anywhere.
- If I save the file to another format using LibreOffice (.xlsx for example), then the problem is gone in the .xlsx but if I then resave the links will be back in LO.
- If I open the file in MS Excel the links are gone, even when I save back to .ods and open in LO. However, a lot of my formatting and calculations are also screwed up.
- The only temporary workaround is to go to Tools > Options > Calc > General and disabling updating of links completely. However, this is poor man’s solution: it affects all my workbooks while the bogus links are still in my file
If there is anyone with a suggestion on how to fix it, that will be greatly appreciated!