Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel formulas
Whenever I copy a cell with a formula to a new cell, the results are the same
in the target cell as it was in the source cell. It doesn't matter what the values are in any cell. |
#2
|
|||
|
|||
The spreadsheet may be set to manual recalculation: press F9 to see if
you get the results you expect. If this is the case and you'd prefer calculation to be automatic, click Tools Options and select the Calculation tab; select Automatic. |
#3
|
|||
|
|||
"Dave O" wrote: The spreadsheet may be set to manual recalculation: press F9 to see if you get the results you expect. If this is the case and you'd prefer calculation to be automatic, click Tools Options and select the Calculation tab; select Automatic. Thanks! that was the solution. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formulas
"Rolaxis" wrote: Whenever I copy a cell with a formula to a new cell, the results are the same in the target cell as it was in the source cell. It doesn't matter what the values are in any cell. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formulas
Perhaps you have absolute addressing? The cell reference contains "$".
Any answer? wrote: "Rolaxis" wrote: Whenever I copy a cell with a formula to a new cell, the results are the same in the target cell as it was in the source cell. It doesn't matter what the values are in any cell. |
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 |