6
(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?
[Yes] [No]
I've always said No. Again, as Edit
menu, 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.
An addition to T.J. Crowder's answer: There is no way to break links in LibreOffice 3.5. Seems like two different bugs in LibreOffice here (not showing the links when you open the .xls file, and not successfully breaking them when saving to no-matter-what-format-is and using Break Link). Bugs got some updates:) P.S. This supposed to be as comment but I have no reputation points here. – user1724911 – 2014-10-01T13:10:05.020
2Thanks T.J. - Your comment actually helped solve my issue where I was trying to identify to a client what the links in a file were and could not see them. Not much good for your scenario, but helped me out. – George Mauer – 2012-05-07T13:44:58.873