I'm using Excel 2002.
I have 30 or so range names in my file. When creating these range names, I
didn't precede the name with the sheet name on any of the names. As I
understand it, this makes all the names Workbook range names.
These range names apply to ranges on several different sheets. When I view
the range names with Insert - Names - Define, with the "Utility" sheet
active, all the names that apply to the "Utility" sheet have the word
"Utility" to the right, opposite the range name. None of the other range
names show the sheet name to the right. When I select any of these
"Utility" sheet names, the "Refers to:" box shows the name of the sheet and
the range as expected..
But when I view the range names (with Insert - Names - Define) when the
"Utility" sheet is NOT active, and I select one of the "Utility" sheet
names, the "Refers to:" box shows "#REF!" and the range.
Why does this happen?
Also, when I select any of the other names, with any sheet active, none of
them display the sheet name to the right, nor have "#REF!" for the sheet
name in the "Refers to:" box.
I thought that perhaps "Utility" was an Excel key word that I shouldn't use
for a sheet name, but the problem persists when I change the name of the
"Utility" sheet.
What is happening? Thanks. John