| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why don't Excel formulas translate in copy/paste or fill down?
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why don't Excel formulas translate in copy/paste or fill down?
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 -- 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why don't Excel formulas translate in copy/paste or fill down?
Perhaps the automatic calculation option was turned off? Check under Tool,
Options, Calculation. "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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why don't Excel formulas translate in copy/paste or fill down?
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set uo a template of formulas in excel | Excel Worksheet Functions | |||
| My custom fill color option is not in excel how do i get it worki. | Excel Discussion (Misc queries) | |||
| The fill feature in Excel that gives option to fill or copy | New Users to Excel | |||
| Putting Excel formatting and/or formulas into CSV file | Excel Discussion (Misc queries) | |||
| Excel won't fill formulas | Excel Worksheet Functions | |||
Linear Mode
