They are especially in demand in the modern business world but casual users also need them from time to time for simple calculations. The pop up regarding links no longer appeared.It’s no secret that spreadsheets are essential for visualizing and analyzing data at all levels. When "Find and Replace" did not find any more instances of "file" in forumulas, I saved and re-opened the sheet. 'file///c:documents/myusername/example.ods'B62Īnd I removed the file reference within the single quotes to leave
(which then refer to the current sheet) EXAMPLE: the search found the formula: In the "Find:" text I typed in "file" (without the quotations).īy clicking on "Find Next" I was able to step through the sheet, finding each cell that had a formula with the text string "file" in it (which represents a link to another file), and removed the complete link to the other file, typically only leaving the actual cell references. 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 kommentar(er)
