software

I've inherited a sheet with thoussands of defined names. Only problem is
that one of the cells I need data from is looking at a defined name that
no longer exists (when I F5 to find it, it is not there). When I double
click through to the cell, an error message comes up.

Two questions:
(1) how can I find which cell (s) the activecell is looking at?
(2) If the defined name no longer exists, could excel be remembering
the last data value that it had before the defined name was deleted, or
will it continue to look in teh same cells, despite the name being
wrong?

Your help would be much appreciated.

Will--
Romanian37
------------------------------------------------------------------------
Romanian37's Profile: www.excelforum.com/member.php...foamp;userid=9759
View this thread: www.excelforum.com/showthread...hreadid=530821Don't know if there's another solution but in the ASAP utilities is a
function to list all the names in a workbook, whether they still exist and
where they are looking.

I have found this very useful in the past.
www.asap-utilities.com

giz

quot;Romanian37quot; wrote:

gt;
gt; I've inherited a sheet with thoussands of defined names. Only problem is
gt; that one of the cells I need data from is looking at a defined name that
gt; no longer exists (when I F5 to find it, it is not there). When I double
gt; click through to the cell, an error message comes up.
gt;
gt; Two questions:
gt; (1) how can I find which cell (s) the activecell is looking at?
gt; (2) If the defined name no longer exists, could excel be remembering
gt; the last data value that it had before the defined name was deleted, or
gt; will it continue to look in teh same cells, despite the name being
gt; wrong?
gt;
gt; Your help would be much appreciated.
gt;
gt; Will
gt;
gt;
gt; --
gt; Romanian37
gt; ------------------------------------------------------------------------
gt; Romanian37's Profile: www.excelforum.com/member.php...foamp;userid=9759
gt; View this thread: www.excelforum.com/showthread...hreadid=530821
gt;
gt;


Have a look at the utilities Findlink and NameManager in reference
below. Any help?

oaltd.co.uk/mvp/--
John James
------------------------------------------------------------------------
John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=530821