Ask Your Question

How to find cells containing file link references in Calc

asked 2017-03-13 19:48:25 +0100

ardor gravatar image

updated 2017-03-13 19:49:55 +0100

I have a large spreadsheet where I apparently and not knowingly managed to insert file link references for a number of cells (the cells present values that are fetched from cells in an external Calc file).

I identified this file link referencing when a formula was malfunctioning and I got division by zero. After some research I identified the cell that caused the problem and found out that the problem was due to this external file referencing.

Same thing happened a couple of more times and I once again needed to search for the cell with the file reference that caused this problem.

My question - is there any way in LibreOffice Calc to highlight all cells that contain external references (if so, then I could systematically replace external references with proper internal ones as I have no need for external references)?

Many thanks in advance for any guidance on this topic.

edit retag flag offensive close merge delete


How the links are done? with formulas?

m.a.riosv gravatar imagem.a.riosv ( 2017-03-13 22:31:20 +0100 )edit

Hi, yes the file references are included in formulas.

ardor gravatar imageardor ( 2017-03-16 18:39:31 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2017-03-16 22:37:20 +0100

m.a.riosv gravatar image

Use the Menu/Edit/Find&Replace tool to search for the cells containing file:///, click on Find all, and all the cells with it are selected.

edit flag offensive delete link more


Thank you!

This solved the problem.

ardor gravatar imageardor ( 2017-03-17 19:04:55 +0100 )edit

DOH!! I had the same question, but as soon as I saw your answer, I realized how simple it was. Often, simplicity is genius.

Thank you

OffGrid9 gravatar imageOffGrid9 ( 2018-03-19 05:48:28 +0100 )edit

Brilliant, this worked for me, too! Thanks!

9littlebees gravatar image9littlebees ( 2018-05-17 09:29:13 +0100 )edit

answered 2019-01-03 02:11:39 +0100

updated 2019-01-03 03:40:32 +0100

Not working in libreoffice Version: (Build ID: 1:6.1.4-1) and 5.0.4 ... Tried with different search patterns, selected advanced search options, ... any clue ?

Found ... Libreoffice reported external file links but the error was related to a formula referring a deleted cell (Depenses.E#REF !) with no error on the column result ... but reporting a link to an external file "file:///home/username/Depenses.E" ...

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-03-13 19:48:25 +0100

Seen: 3,305 times

Last updated: Jan 03 '19