Instead of Fill Down, try Fill Series (bottom of drop-down)

"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?