Do you have an add-in or utility running that is creating these names? In
VBA you can hide defined names from the UI.
Jan Karel Pieterse's Name Manager (
http://jkp-ads.com) is much more capable
at handling names than Excel's UI. It allows you to see all names, including
hidden names, and you can filter on a number of parameters. I'm sure this
would let you see where these names are and delete the names with errors.
Maybe even figure out where they are coming from.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"Carl" wrote in message
...
I just found 4,700 bad references (#REF!) in my workbook. The software used
to find the "#REF!" link gave the message, "Found links in Hidden name
[worksheet name]!Uniformances17R147C5:='[worksheet name]'!#REF!" Does
anyone
know how this might be happening? I know it means I have lost the
reference
in a formula by doing something like deleting a worksheet it was
referencing
but that has not happened. Thanks in advance.