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

MSFT has an Excel 2007 blog. It can be found by googling "excle 2007 blog"

You can contact the development team there.

Dave
--
Brevity is the soul of wit.


"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

I'm in the beta if you want to send it to me.

--
Jim
"charlier" wrote in message
...
| 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

Hi charlier,

If you wouldn't mind sending me the file where you are not seeing references
updated correctly, I'd love to take a look at it.

Cheers,
Dan
Excel Team

Note: We've only got a couple weeks to get bugs filed and fixed, so if I've
requested additional info via email, it'd be great if you can get that to us
ASAP. Please include any necessary sample files, as well as detailed repro
steps so that we can try to reproduce the problem on our side. Also - if
you're emailing me directly (definitely the most efficient at this point)
you'll want to fixup my email address to remove everything after danbatt and
before the @.


"charlier" wrote in message
...
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

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