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

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

Ted L.
26 ●4 ●6 ●7

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 flag offensive close merge delete

Comments

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

PèreOrval ( 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!)

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

add a comment

1

answered 2018-06-11 05:33:27 +0200

Ted L.
26 ●4 ●6 ●7

updated 2018-06-23 12:01:34 +0200

David

flag of United Kingdom of Great Britain and Northern Ireland

5668 ●53 ●91 ●152

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