Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

(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.

share|improve this question
2  
Thanks 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 May 7 '12 at 13:44
    
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 Oct 1 at 13:10

2 Answers 2

up vote 4 down vote accepted

I found a workaround. Hopefully somebody will have a better answer, but if not, perhaps this will help anyone else having the same problem.

Here's the workaround (this was with LibreOffice 3.4.4):

  1. Open the .xls file
  2. Say "No" to the question
  3. Save the file as an OpenOffice.org 1.0 spreadsheet (.sxc) (not .ods, that won't work, see the update at the end of the question)
  4. Open the new .sxc file
  5. Say "No" to the question
  6. Go to Edit | Links...
  7. Break any links you find
  8. Save the file
  9. Use "Save as" to save it back to whatever format you actually want (.xls, .ods, etc.)
  10. Delete the temporary .sxc file

Now the links are well and truly broken. 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 .ods and using Break Link), which I'll go report.

share|improve this answer

The links may be in range names, try look at Insert|Names|Manage there may be range names created by Excel that were linked to external files

share|improve this answer
    
Please expand your answer. –  Lee Taylor Mar 19 '13 at 12:32

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.