why won't my excel spreadsheet formulas update when I copy them?
 

why won't my excel spreadsheet formulas update when I copy them?
 

A little more detail would help, but perhaps you have absolute
addresses in the formula, so they will always calculate to the same
value. Perhaps your worksheet is set to Manual Calculation mode (click
on Tools | Options | Calculation tab to change it). Or maybe the cell
is formatted as text - format the cell(s) as General, then F2 followed
by <Enter to change them.

Hope this helps.

Pete

On Apr 7, 9:32*pm, Espresso Wendy <Espresso
wrote:

why won't my excel spreadsheet formulas update when I copy them?
 

On Tuesday, 8 April 2008 00:32:03 UTC+4, Espresso Wendy wrote:


thank you very much....its a new lesson for me .// past few days am trying to solve the issue.. thanks.....now its working