What cells depend on an external link ?

General discussion on OpenOffice Calc and its spreadsheets.

What cells depend on an external link ?

Postby Keya_LOT » Fri Nov 14, 2014 12:30 pm

Hi Everyone,

One of my spreadsheets depends (according to Edit>Links) on the external file XYZ.ods.
I suspect this is wrong; maybe the cells should depend on some new version of XYZ.ods.
How to determine which cells use this link ?

Thanks in Advance,
Posts: 24
Joined: Tue Mar 25, 2014 6:35 am

Re: What cells depend on an external link ?

Postby Jill R. Lipe » Sat Nov 15, 2014 7:20 am


Please follow the instruction mention below:
menu > edit > find & replace
search for .ods (dot ods)
under 'more options' make sure 'search in' is on formulas (this is the default)
find all

Hope it will be helpful for you.

Jill R. Lipe
Posts: 33
Joined: Mon Mar 24, 2014 6:30 am

Re: What cells depend on an external link ?

Postby Ricky G. Marion » Sat Nov 15, 2014 10:33 am


However there are several ways links may be created between Calc documents.

My suggestion should be good for cell formula references to an external file, but you may also create links to named ranges in another document via Insert > Link to External Data, or to a sheet in another doc with Insert > Sheet from File.

Maybe the quickest way to check the details on these last 2 is to look for AreaLinks and SheetLinks using MRI or XRay.
In the case of named ranges through Link to External Data, the range name should show up in the Edit > Links dialog.

Hope this will helps you.
Ricky G. Marion
Posts: 25
Joined: Mon Mar 24, 2014 6:33 am

Return to OpenOffice.org Calc

Who is online

Users browsing this forum: No registered users and 0 guests