Named ranges

[ChrisUK]

OK, I need some help understanding how these work!

I have a workbook which I'm trouble shooting on. Its doing lots of crazy things and the machine performance is being brought into question. I'm working through all the faults one by one but I've come across some named ranges which are no longer there.

If I go to Insert, Name, Define I can see literally hundreds of names many of which point to PC's which are no longer there or to drives which have been disconnected long ago.

My question is how does Excel use these named ranges? Does it try and resolve them when the workbook is opened? I'm not getting any warning messages so I guess not but the performance thing is worrying me a bit as if Excel is looking for thes ranges and finding them not there ... am I making sense?

Anyway, I'm rather hoping someone out there can guide me a bit please

Thanks

Chris

 

[texasalynn]

this add-in helps with range names/links

http://www.oaltd.co.uk/DLCount/DLCount.asp?file=FindLink.zip

 

[ChrisUK]

Thanks but I'm not interested in finding the missing links, there are hundreds and I suspect almost all are not used. What I want to understand is how does Excel go about resolving these links? Does it read all named ranges in at the start or just when you try to call them?

I just want to understand how Excel treats named ranges

TIA

Chris

BTW - I use a MAC so the add in didn't work as I don't have any VB