Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why Excel does automatically change the formula?
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula help to change row colour automatically by some conditions | Excel Worksheet Functions | |||
excel macro to automatically change default printer | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Can you change something in Excel to automatically insert an equa. | Excel Discussion (Misc queries) | |||
How do I change the Cell color automatically in an Excel sheet wh. | Excel Worksheet Functions |