Check this:

http://www.jkp-ads.com/RefTreeAnalyser.asp

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Michael.Tarnowski" wrote in message
...
Hi Mike,
thanks for your tip. This gives a list of the definitions, but I'am
looking for a kind of list, in which cell of which sheet a name is
*used*. In other words, which cell is effected if a name definition is
deleted.
Michael

Mike H wrote:
hi,

Select a cell where you want the list then

Insert|Names|Paste and paste list

Mike

"Michael.Tarnowski" wrote:

Hi community,
is it possible - and if, how - to get a kind a map i.e. reference,
where defined names are used in a workbook?
Cheers Michael