I'm having the exact same error - when using an older version of Excel on
another computer, copying a row with a formula will keep the new formula
relative.

In the new beta, the formula become absolute (i.e. refering exactly to the
same location as the original formula).


"charlier" wrote:

In some cases, when copying a cell (formula) to other location the relative
references are no updated. For instance: cell B3 = A3. When I copy B3 to B4
the formula remains A3 (instead of A4). I have a file to show the problem. I
just do not know to whom should I send the file.
--
rc