| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Formulas not calculating when dragging down
When I am in a spreadsheet and I drag a formula down it does not calculate
unless I double click. What is going on? This has just started happening and not sure how to fix. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 Formulas not calculating when dragging down
Tools - Options - Calculation - Automatic
-- HTH... Jim Thomlinson "Amy" wrote: When I am in a spreadsheet and I drag a formula down it does not calculate unless I double click. What is going on? This has just started happening and not sure how to fix. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 Formulas not calculating when dragging down
THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
"Jim Thomlinson" wrote: Tools - Options - Calculation - Automatic -- HTH... Jim Thomlinson "Amy" wrote: When I am in a spreadsheet and I drag a formula down it does not calculate unless I double click. What is going on? This has just started happening and not sure how to fix. Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 Formulas not calculating when dragging down
Click Tools/Options in Excel's menu bar, click the Calculation tab and see
if your calculations have been changed to Manual (if so, make them Automatic). -- Rick (MVP - Excel) "Amy" wrote in message ... When I am in a spreadsheet and I drag a formula down it does not calculate unless I double click. What is going on? This has just started happening and not sure how to fix. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cells highlight when dragging mouse : Microsoft, Excel, 2003 | Excel Discussion (Misc queries) | |||
| Dragging formulas | Excel Worksheet Functions | |||
| Dragging Formulas | Excel Discussion (Misc queries) | |||
| Dragging formulas | Excel Worksheet Functions | |||
| Dragging formulas | Excel Worksheet Functions | |||
Linear Mode
