Mac Forum / Applications / MS Office / October 2005

Having difficulty in applying Book-Level and Sheet-Level Names in
Workbooks.
When I define a name in the Define Name dialog box and I then select
the name in the Name Box, it will select the reference on the worksheet
that I have used to define the name.
If I then move to another worksheet in the same workbook with identical
layout, the name I have defined appears in the Name Box, but when I
select it, it returns to select the reference in the Worksheet where I
made the original definition.
This does not always happen but I cannot find a sure way of defining
names in one worksheet that will always work in other worksheets with
similar layoute.
Any suggestions please.