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