Some formulas don't track copies, pastes, fill right, fill down
 

I have a problem with the new Excel TR2. I have an extensive file that I
update frequently. Some of the formulas in the cells are quite complex. When
I want to do some new stuff, I usually select a column of cells and the next
column to the right, and then hit ctrl-r to copy right.

In the past with Office 2007, this has worked just as I expected; i.e.
formulas in the cell are automatcially incremented in the news column. E.g.,
if one cell has the formulat "=G1" and I copy right, the new cell one row of
has "=H1".

Now it Excel doesn't do make the change from G column to H column in the new
cell that I ctrl-r on (cut and paste also don't work). Althought it's more
weird than than. Currenlty I have about 50 rows. If I select the last cell
in row 1 and the next empty cell to the right, and then hit crtl-r, in my
current case the old row has "data!GM1" and the new cell does update to
"data!GN1." But IF I drag and select all 50 rows in the last column and the
next empty column and ctrl-r, this new cell has "data!GM1," as does the rest
of the rows.

How do I fix this? Is this a bug or a setting?

Thanks!

Some formulas don't track copies, pastes, fill right, fill down
 

dont forget excel 2007 is still a beta!
--
paul

remove nospam for email addy!



"whiten" wrote:

I have a problem with the new Excel TR2. I have an extensive file that I
update frequently. Some of the formulas in the cells are quite complex. When
I want to do some new stuff, I usually select a column of cells and the next
column to the right, and then hit ctrl-r to copy right.

In the past with Office 2007, this has worked just as I expected; i.e.
formulas in the cell are automatcially incremented in the news column. E.g.,
if one cell has the formulat "=G1" and I copy right, the new cell one row of
has "=H1".

Now it Excel doesn't do make the change from G column to H column in the new
cell that I ctrl-r on (cut and paste also don't work). Althought it's more
weird than than. Currenlty I have about 50 rows. If I select the last cell
in row 1 and the next empty cell to the right, and then hit crtl-r, in my
current case the old row has "data!GM1" and the new cell does update to
"data!GN1." But IF I drag and select all 50 rows in the last column and the
next empty column and ctrl-r, this new cell has "data!GM1," as does the rest
of the rows.

How do I fix this? Is this a bug or a setting?

Thanks!

Some formulas don't track copies, pastes, fill right, fill dow
 

Uh, Paul, Duh. I think this is a beta forum (linked to at least from the
Office Beta website). My post was not only to give MS some feedback about a
potential problem, but also to help find a work around (or setting) if one
existed.

Okay, so with that aside, here is a work around and something for the MS
gurus to look at. Seems that the problem is associated with conditional
formatting. When I "clear rules from selected cells" before crtl-r or copy
or anything else. Then do the ctrl-r, copy, etc., the cells update correctly
into the new cells. Then I can go back to the previous cells that still
contain the conditional formatting, and paste special, formats, and I'm back
to where I wanted to be in the first place. A few extra steps here for now,
but hopefully this is something MS can find and fix.

MS folks, email me if you want and I can send the spreadsheet to you to look
at.

"paul" wrote:

dont forget excel 2007 is still a beta!
--
paul

remove nospam for email addy!


<snip
"whiten" wrote:
How do I fix this? Is this a bug or a setting?