Please help: identify where an automatic link to other spreadsheet is?
 

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?

Please help: identify where an automatic link to other spreadsheet is?
 

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

Please help: identify where an automatic link to other spreadsheet is?
 

"starguy" wrote in
message ...

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



no, that doesn't help - you get that prompt on startup anyway (not to
mention the option to break/remove links often crashes excel)

I want to know which cells are linking to the external sheets.





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

Please help: identify where an automatic link to other spreadsheet is?
 

Lee

Download and use Bill Manville's FindLink program:

http://www.oaltd.co.uk/MVP/Default.htm


Gord Dibben MS Excel MVP

On Fri, 18 Aug 2006 08:28:58 GMT, "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?


Gord Dibben MS Excel MVP

Please help: identify where an automatic link to other spreadsheet is?
 

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Lee

Download and use Bill Manville's FindLink program:

http://www.oaltd.co.uk/MVP/Default.htm


Gord Dibben MS Excel MVP

many thanks Gord



On Fri, 18 Aug 2006 08:28:58 GMT, "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?


Gord Dibben MS Excel MVP

Please help: identify where an automatic link to other spreadsheet is?
 

Thanks Lee

Bill's add-in has saved a lot of work for many over the years.


Gord Dibben MS Excel MVP

On Fri, 18 Aug 2006 23:32:25 GMT, "Lee Harris" wrote:


"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
Lee

Download and use Bill Manville's FindLink program:

http://www.oaltd.co.uk/MVP/Default.htm


Gord Dibben MS Excel MVP

many thanks Gord



On Fri, 18 Aug 2006 08:28:58 GMT, "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?


Gord Dibben MS Excel MVP