auto compute
Make sure calculation is set to automatic...
In versions prior to Excel 2007...
ToolsOptionsCalculation tabAutomaticOK
--
Biff
Microsoft Excel MVP
"Joseph" wrote in message
...
My excel's formula is not currently funtioning automatically.
An example is when I'm copying a formula to be pasted in multiple cells
either any direction, it only gives me the amount that I copied although
the
formula bar shows the formula copied refers to different cells and values.
I
also found out that it will only calculate everytime I press F2 and enter.
What if I need tens thousands of cells, I cannot afford to do it on every
cell. Please help. tnx
|