Disappearing Names in Excel 2007

[Daryl Fagala]

In at least one Excel 2007 macro-enabled workbook, names I give to certain
cells or ranges disappear from the list in the Name dropdown box as well as
Name Manager when I close and then re-open the workbook. I've been careful to
make sure I save the workbook each time I create a name but they still
disappear on re-opening. Is anyone else having this problem and, if so, found
the solution?

 

[Dave Peterson]

There are some names that won't appear in the namebox. And some names can be
marked as not visible.

Any chance you're seeing one of these?

Just curious...

What is the name that's disappearing and what does it refer to? Maybe someone
running xl2007 will notice a problem with more info.

 

[Daryl Fagala]

Thanks, but I don't think that's the problem. The names don't appear in Name
Manager even with all the filters off. Plus, I get an error when the macro
tries to go to the named range.

 

[Chip Pearson]

A name can have workbook level scope, which means that once defined, it can
be used in any cell on any worksheet. A name can also have worksheet level
scope, and that name is visible only on the worksheet on which it is
defined. My guess is that you are dealing with names and inadvertently were
defined with worksheet, not workbook, level scope.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[pklein4]

A name can have workbook level scope, which means that once defined, it can
be used in any cell on any worksheet. A name can also have worksheet level
scope, and that name is visible only on the worksheet on which it is
defined.  My guess is that you are dealing withnamesand inadvertently were
defined with worksheet, not workbook, level scope.

--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
   ExcelProduct Group, 1998 - 2008
Pearson Software Consulting, LLCwww.cpearson.com
(email on web site)






- Show quoted text -

We've had the same problem with names disappearing in Excel 2007.
Oddly enough it appears that the same names disappear each time. For a
while we thought we had the problem fixed: We uninstalled an unrelated
program and reinstalled Excel - the problem went away for a week but
now it is back. We have thourougly investigated the possibilty that it
is a scope and/or visibilty issue, and we are certain that it is not!
Any insight?
Peter Klein