#ref!#ref error for named cells or ranges

**StuCram** · 01-08-2015, 06:56 PM

Sometimes when I have duplicated & deleted sheets in Excel, I end up with some of the named cells or regions being undefined. When I examine them in the 'Define Names' dialog, they refer to "#Ref!#Ref" instead of an actual sheet and cell such as "Junior!P31".

It's frustrating to go through the entire list of named items manually to find such entries and remove them.

My question: Is there an easy way to examine all the user names for cells and regions?

**protonLeah** · 01-08-2015, 07:05 PM

http://www.jkp-ads.com/officemarketplacenm-en.asp

**StuCram** · 01-08-2015, 07:32 PM

Thanks ProtonLeah. That seemed to be just what I needed to mange the names.

However, it fails to appear in any menus in Excel 11 for Mac even though it is selected in the add-ins dialog.

Any suggestions would be appreciated.

-Stu