Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to find cells containing file link references in Calc

I have a large spreadsheet where I apparently and not knowingly managed to insert file link references for a number of cells (the cells presents 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 references.

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 (I have no need for external references)?

Many thanks in advance for any guidance on this topic.

How to find cells containing file link references in Calc

I have a large spreadsheet where I apparently and not knowingly managed to insert file link references for a number of cells (the cells presents 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 references.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 (I as I have no need for external references)?

Many thanks in advance for any guidance on this topic.