| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copied formulas on Excel the value doesn't change
When i copied formulas from D1 through D6, why is it that D2 to D6 valve is
the same as D1? But the cell refects the correct formulas. A B C D 1 122 455 577 2 528 45 577 3 3214 12 577 4 980 12444 577 5 154 87 577 6 31274 855 577 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copied formulas on Excel the value doesn't change
D1 =B1+C1
copy from D1 to D6 "Jane" wrote: When i copied formulas from D1 through D6, why is it that D2 to D6 valve is the same as D1? But the cell refects the correct formulas. A B C D 1 122 455 577 2 528 45 577 3 3214 12 577 4 980 12444 577 5 154 87 577 6 31274 855 577 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copied formulas on Excel the value doesn't change
When i copied formulas from D1 through D6,
why is it that D2 to D6 value is the same as D1? The calc mode may be inadvertently set to Manual. Press F9, does it now compute properly? To check/change calc mode: Click Tools Options Calculation tab. Options are there. Ensure "Automatic" is checked OK. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Jane" wrote: When i copied formulas from D1 through D6, why is it that D2 to D6 valve is the same as D1? But the cell refects the correct formulas. A B C D 1 122 455 577 2 528 45 577 3 3214 12 577 4 980 12444 577 5 154 87 577 6 31274 855 577 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Microsoft Excel - Automatically Extending Formulas | Excel Discussion (Misc queries) | |||
| How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Hybrid Mode
