# Can't get rid of "this file contains links to other files."

I have a calc spreadsheet in which I made a link to an external file. I no longer need that link and cleared (deleted) the cell containing it. But I still get that message when I open the file! I have searched the entire file for "file" or "///" in formulas and can't find any other cell that I might have created that has such a reference. (The file has about 10 sheets in it and is pretty big, so it's not easy to search it manually.) I also tried "breaking" the link from the edit menu, but that did no good. Ideas anyone?

edit retag close merge delete

Make a copy of the file. Delete the sheets until the problem goes away. In this way you can probably pinpoint the problem faster.

( 2018-06-10 09:55:10 +0200 )edit

I did that! I tried deleting (clearing) the contents of all spreadsheets and still got the message. See my answer below on what seems to be the underlying problem (track changes still remembers a link even if it's been deleted and the delete accepted!)

( 2018-06-11 05:33:03 +0200 )edit

Sort by » oldest newest most voted

I think I have found the problem, not that it gives an answer!

I have track changes turned on. Even though I have deleted the contents of the cell containing the link, the history of changes still contains the original link. Even if I try to "accept" the change for that one cell, the change history still remembers (records) that the original contents were rejected.

If I turn change tracking off, the "this file contains a link" message goes away, presumably because all change history goes away.

FYI, breaking the link doesn't help, and I gather from what I've read elsewhere that doesn't work for links that are of the kind =file///….

I haven't been able to find any way to remove the tracking history for just one cell; presumably there might be one. (I may play around and come up with a simple, reproducible example, and submit it as a bug, although I guess it's really a feature request.)

more

I think you can break the links on Menu/Edit/Links to external data

more

You may find some relevant information in this recent thread of a better structured forum on free office software.

more

## Stats

Asked: 2018-06-10 04:02:00 +0200

Seen: 2,287 times

Last updated: Jun 23 '18