Ask Your Question
0

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

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

Ted L. gravatar image

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 gravatar imagePè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. gravatar imageTed L. ( 2018-06-11 05:33:03 +0200 )edit

3 Answers

Sort by » oldest newest most voted
1

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

Ted L. gravatar image

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

David gravatar image

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

edit flag offensive delete link more
0

answered 2018-06-10 12:16:21 +0200

Lupp gravatar image

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

edit flag offensive delete link more
0

answered 2018-06-10 13:45:54 +0200

m.a.riosv gravatar image

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 703 times

Last updated: Jun 23 '18