Excel 2007
 

I have a worksheet in the new excel 2007 beta 2 technical refresh

Copy/Paste and fill down aren't translating formulas like they should. Is
there a bug or a setting somewhere i don't know about?

cell G31 has formula =F31*$D31. If i fill this down or copy it to G32, i
expect G32 to have the formula =F32*$D32, but it doesn't it gets the exact
same formula as F31 - no translation happens.
Anyone know what's up here?

Excel 2007
 

See my response to your other post.

Dave
--
Brevity is the soul of wit.


"Janunson" wrote:

I have a worksheet in the new excel 2007 beta 2 technical refresh

Copy/Paste and fill down aren't translating formulas like they should. Is
there a bug or a setting somewhere i don't know about?

cell G31 has formula =F31*$D31. If i fill this down or copy it to G32, i
expect G32 to have the formula =F32*$D32, but it doesn't it gets the exact
same formula as F31 - no translation happens.
Anyone know what's up here?