go to menu Edit Links...
and remove the link you do not require.

Lee Harris Wrote:
I have a spreadsheet with links to a couple of other sheets. However,
how
can I find out which cells are linking to other sheets if I've
forgotten? It
is a huge sheet, and when I open it and click "update" it complains
about
one of the linked sheets being missing - I need to remove the link to
that
sheet as it's no longer valid, but how on earth do i find out where in
my
sheet it's looking for this other sheet?

surely there must be a simple way to find out?


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=572979