Hi,

When I am using a defined name, say EndDate, in formula it works fine (i.e.
: =EndDate). But when I precede the defined name by the name of the sheet
where the cells defining the name are located, Microsoft Excel replace
automatically the name of the sheet by the name of the workbook. For example
if the name €œEndDate€� refers to cells contained in the sheet named €œRef€� in
the workbook named €œMyBook.xls€�. If I enter the formula €œ=Ref!EndDate€� in a
cell of another worksheet of the same workbook, Excel will automatically
replace the formula by: €œ=MyBook!EndDate€�.

Thanks for any help.