I have two name ranges that are not duplicates but produce an error
message when I try to create them using either one of the names
below. There are no spaces, just underlines in the attempted named
range:
C100_Division_of_Program_Integrity
2000_Division_of_Protection_and_Permanency

If I take the range and name it "test" or anything similar and
shorter, then Excel accepts the name and creates the named range.
What is strange is that I have a similar named range:
A200_Office_of_Legislative_and_Public_Affairs that Excel took without
an error message.

The C100_Division...... name is not listed elsewhere. I have
installed the name manager add-in and it is not listed. I do have a
lot of named ranges but why will it take the shorter "test" but not
the longer name (with underlines, no spaces) ?? I am using Excel 2003.