(I don't believe this is duplicate of LibreOffice Calc prompting to update “links to other files”. Why?. See below for why.)
The title basically says it. I have an .xls file originally created with Excel 2007. As far as I'm aware, it doesn't have any links in it, and
Links... on the
Edit menu is disabled (greyed-out). When I open it in LibreOffice 3.4.4, it asks
This file contains links to other files.
Should they be updated?
I've always said No. Again, as
Links... is greyed-out, apparently there aren't really any external links. I don't think the file even has internal links. It does have multiple worksheets in it.
I've seen the question I mentioned above, but the OP wasn't sure whether
Edit | Links... used to be active and stopped getting the question, and the only answer there assumes that
Edit | Links... was active, so clearly not an answer to what I'm looking at.
How do I fix the file so I don't get this question every time I open it (without changing my options to always update links)?
Immediately after posting the question, I thought: I wonder if saving it as an .ods file will fix it. So I did that, and then opened the .ods file. I got the question, but when I say "No," the
Edit | Links... menu item is enabled, and when I go into it, I find what LibreOffice thinks are links to other files.
So I thought I had an answer, but sadly no. If I tell it to break both of the links it displays and save the .ods file, the next time I go back in, one of the links reappears on the list. Removing it again, resaving, and going back in don't help; I did it at least four times and the link just keeps reappearing.