Ask Your Question
0

how to find external links

asked 2020-06-28 21:08:58 +0200

BeCheerful gravatar image

updated 2020-06-29 01:26:18 +0200

I keep being told that I need to update my external links. I thought I got rid of them all. I've tried to search for the link that is shown in Edit/Links to External Links and I find nothing. So where are my links?

Answer is:
The spreadsheet was corrupted.

edit retag flag offensive close merge delete

Comments

@BeCheerful,

Do a search for "file:///".

If you want to add more information, you can edit your question; also can comment an answer. Do not use Answer to comment.

LeroyG gravatar imageLeroyG ( 2020-06-28 21:18:31 +0200 )edit

I tried searching for file:/// it says Search key not found. I also turned on formulas and tried to find one.

BeCheerful gravatar imageBeCheerful ( 2020-06-28 21:34:23 +0200 )edit

@BeCheerful,

Searched with Regular expressions unchecked?

Would you share the file? Before remove sensible data from it. To do that, edit your question and use the paperclip.

LeroyG gravatar imageLeroyG ( 2020-06-28 21:46:45 +0200 )edit
1

There are many kinds of external links possible. A formula referring to an external file; or an external file linked as a sheet; or a linked image; ...

Note that file:// is not the only possible kind of external URL. If you use relative URL, it might not include a protocol at all. Or you may reference e.g. something from http(s).

Mike Kaganski gravatar imageMike Kaganski ( 2020-06-28 21:57:44 +0200 )edit

The file is this month's food log (in work) I'm not uncomfortable. But it is beyond the max load to be sent. I am going to try parts into a blank and so see if I can track down the issue that wa

BeCheerful gravatar imageBeCheerful ( 2020-06-28 22:19:40 +0200 )edit

the only thing that I would have linked to this spreadsheet is another spreadsheet that I made. It is listed but I can not find the link. I tried bringing the first page over to a new file. It came over with it. So I made another spreadsheet and copied and pasted the area with the info and it did not move with it so I believe my spreadsheet is corrupted.

BeCheerful gravatar imageBeCheerful ( 2020-06-28 23:04:03 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2020-06-29 00:31:59 +0200

LeroyG gravatar image

updated 2020-06-29 00:32:32 +0200

Choose menu Edit - Links to External Files…, select the source file listed there, and see what link appear below (text blue, underlined). Search for that in the document. Leave it if it's useful.

From the LibreOffice Help on Edit Link: "This command is not available if the current document does not contain links to other files."

Mark the circle to the left of the answer that solves your question.

edit flag offensive delete link more

Comments

The spreadsheet was corrupted.

BeCheerful gravatar imageBeCheerful ( 2020-06-29 01:23:55 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-06-28 21:08:58 +0200

Seen: 21 times

Last updated: Jun 29