Why don't Excel formulas translate in copy/paste or fill down?

G

Guest

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

Guest

The short answer to your question is that XL 2007 is a beta version of Excel,
and, therefore, there may be some bugs in it.

If you want more detail on this issue, I would contact the developers
directly, via their blog: http://blogs.msdn.com/excel/

Dave
 
G

Guest

Perhaps the automatic calculation option was turned off? Check under Tool,
Options, Calculation.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 1
I want paste / fill to NOT copy cell formatting 3
Excel should have a "Copy absolute formulas " in Paste Special. 5
automatically fill in formula 3
Copy and Paste in Excel, copies cell and formula, but shows same v 3
Macro to fill down automatically the number of rows in a spreadsheet 1
Some formulas don't track copies, pastes, fill right, fill down 2
Excel can automatically put in formulas...or not?! 1

Top