J
Jante
If I use the fill handle to copy a formula, the formulas are well copied, but
the results are not. Exemple: The formula in A3 is =A1+A2. If I copy the
formula to B3 it reads =B1+B2, which is correct. The result given in B3
however is not B1+B2 but the same result as in A3. I have to recalculate the
formule in B3 for the correct result. In previous versions Excel did this
automatically. How can I fix this problem or is it a bug?
the results are not. Exemple: The formula in A3 is =A1+A2. If I copy the
formula to B3 it reads =B1+B2, which is correct. The result given in B3
however is not B1+B2 but the same result as in A3. I have to recalculate the
formule in B3 for the correct result. In previous versions Excel did this
automatically. How can I fix this problem or is it a bug?