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.