| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel formulas
When a formula is copied using the drag feature, the result in the new cells
remian the same as it is for the original cell. For example if the formula in cell G34 is =f34*3 and the result of the formula is 120 and then that formula is dragged to G35, the result is still 120, even though the result should be something other than 120. This is happening on any worksheet, even after a repair has benn done. The version of Excel is Office 2K3, Windows XP Pro is the OS. |
|
#2
|
|||
|
|||
|
Maybe Calculation is set to Manual?
ToolsOptionsCalculation and select Automatic -- Regards Roger Govier "Rolaxis" wrote in message ... When a formula is copied using the drag feature, the result in the new cells remian the same as it is for the original cell. For example if the formula in cell G34 is =f34*3 and the result of the formula is 120 and then that formula is dragged to G35, the result is still 120, even though the result should be something other than 120. This is happening on any worksheet, even after a repair has benn done. The version of Excel is Office 2K3, Windows XP Pro is the OS. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple formulas in existing Excel 2002 no longer working. | Excel Worksheet Functions | |||
| Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
| I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
| How do I save a copy of an excel file without the formulas? | Excel Worksheet Functions | |||
| Problems with Excel formulas when 2002 upgraded to XP | Excel Worksheet Functions | |||
Linear Mode
