defned names problem

[Romanian37]

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

[Gizmo63]

Don'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

"Romanian37" wrote:

>
> 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: http://www.excelforum.com/member.php...fo&userid=9759
> View this thread: http://www.excelforum.com/showthread...hreadid=530821
>
>

[John James]

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

http://oaltd.co.uk/mvp/