Finding the cell that is linked to a file
 

Quick question here.

I have a file which is linked to other files. One file isn't one I own
and I would rather not link to it, but I can't determine which cell is
pulling data from that file.

Any idea how I find that cell?

I know I could use CTRL + ¬ but that means I have to go through every
cell including ones in hidden columns - is there an easier way?

Thanks

Simon


--
kosciosco
------------------------------------------------------------------------
kosciosco's Profile: http://www.excelforum.com/member.php...fo&userid=7068
View this thread: http://www.excelforum.com/showthread...hreadid=473780

Use EditFind and make sure Look In: lists "Formulas" and then in
"Options" choose Workbook to look in all sheets within your workbook.

Enter a phrase that is contained in the link you are looking for, e.g.
"[Book2.xls]Sheet1" that identifies the file you are linking to... and
click Find Next.

Good Luck!


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=473780

When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

And depending on what version of excel you're running, you may be able to use:

Edit|Links
select the link you don't want
and click the Break link button

kosciosco wrote:

Quick question here.

I have a file which is linked to other files. One file isn't one I own
and I would rather not link to it, but I can't determine which cell is
pulling data from that file.

Any idea how I find that cell?

I know I could use CTRL + ¬ but that means I have to go through every
cell including ones in hidden columns - is there an easier way?

Thanks

Simon

--
kosciosco
------------------------------------------------------------------------
kosciosco's Profile: http://www.excelforum.com/member.php...fo&userid=7068
View this thread: http://www.excelforum.com/showthread...hreadid=473780

--

Dave Peterson