Used Find and Replace, I changed the options to look in 'Formulas', and to look at 'All sheets' in the book. How can I find cells in my spreadsheet that have formulas linked to other files, so I can change the contents of THOSE cells so that they no longer link to other files?įollowing snippets of the conversation here, I tried this: I came to this page looking how to get rid of that pop up - that is:

The spreadsheet I was opening was copied from another one, but each spreadsheet should stand on its own. So it seems that there is a hidden sheet in my file.Įvery time I opened up a Calc Sheet I had copied, I received the same pop up 'This file contains links to other files. fods file, so searching through the xml source is something I can do I found. So: how do I find and remove the alleged external links.ĮDIT: I am using a. Searching for ///, ://, *.*s did not return any results.

(Edited, had erroneous External > Links before.) The only hints I found were on the LibreOffice Forums: īased on these hints, I investigated and found out the following: (I assume this issue is not specific to LibreOffice, but also present in OpenOffice.)

I did not add external links myself, but did copy data from another Calc window at one point, after which this issue started. I have a LibreOffice Calc spreadsheet which pops up a message asking me whether I wish to update external links.

Open libreoffice calc