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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |