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.

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.

Thanks, John. I only have MS Query installed. I am doing a lot of deleting
and adding charts (or was before). Is there a correct way to delete a chart
without leaving hidden charts in the workbook? The Name Manager utility is
great. Thanks! I still need to find out what I am doing to create the problem
however.

"Jon Peltier" wrote:

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.

Why do you have hidden charts?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Carl" wrote in message
...
Thanks, John. I only have MS Query installed. I am doing a lot of deleting
and adding charts (or was before). Is there a correct way to delete a
chart
without leaving hidden charts in the workbook? The Name Manager utility is
great. Thanks! I still need to find out what I am doing to create the
problem
however.

"Jon Peltier" wrote:

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.