excel, multiply problem
 

I've done it a million times, taking the formula of a cell and copy that
formule to the rest of the sheet, to get the same calculation. suddenly it
doesnt work and it just copies the value of the cell I copied, not the
formalu, although it shows the formula in the cell!
can anyone help me here.

excel, multiply problem
 

Are they static references such as $A$1, if so it will calculate the same no
matter where you put it
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"hans" wrote:

I've done it a million times, taking the formula of a cell and copy that
formule to the rest of the sheet, to get the same calculation. suddenly it
doesnt work and it just copies the value of the cell I copied, not the
formalu, although it shows the formula in the cell!
can anyone help me here.

excel, multiply problem
 

ToolsOptionsCalculation.

Make sure you are set to "automatic".


Gord Dibben MS Excel MVP

On Thu, 18 Jan 2007 19:10:00 -0800, hans wrote:

I've done it a million times, taking the formula of a cell and copy that
formule to the rest of the sheet, to get the same calculation. suddenly it
doesnt work and it just copies the value of the cell I copied, not the
formalu, although it shows the formula in the cell!
can anyone help me here.