I think you forgot to include the sheetname in the names in workbook box (in the
Insert|Name|Define dialog):

Sheet1!gross.sales
or
'sheet 1'!gross.sales

This behavior didn't change with xl2002--it was the same way in xl2k and xl97
and ....

Reds wrote:

I am new to Excel 2002. In prior versions I could create sheet specific
names easily. With Excel 2002 every time I try to re use a name on another
sheet (same workbook) the name gets moved to the new sheet. I use several
workbooks (one book for sales, one for cost of goods, etc), with 12 sheets
named for each month of the year. Each sheet is a duplicate of the first.
As the year progresses I fill in the data at the end of each month. In the
past I used the same names(Gross.Sales for example) on each sheet in the
workbook. I then can build monthly summary reports using these names. I
cannot get it to work in Excel 2002. Any suggestions?
Thanks for your help

--

Dave Peterson