| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2007 Beta-Charting | Charts and Charting in Excel | |||
| Weakness in the Drag Function of Excel 2007 (Beta) | Excel Worksheet Functions | |||
| Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel, even 2007 beta | Excel Discussion (Misc queries) | |||
| excel 2007 beta text box printing | Excel Discussion (Misc queries) | |||
| Trouble opening large size Excel file 155Mb in Excel 2007 | Excel Discussion (Misc queries) | |||
Linear Mode
