| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto compute
My excel's formula is not currently funtioning automatically.
An example is when I'm copying a formula to be pasted in multiple cells either any direction, it only gives me the amount that I copied although the formula bar shows the formula copied refers to different cells and values. I also found out that it will only calculate everytime I press F2 and enter. What if I need tens thousands of cells, I cannot afford to do it on every cell. Please help. tnx |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
auto compute
Make sure calculation is set to automatic...
In versions prior to Excel 2007... ToolsOptionsCalculation tabAutomaticOK -- Biff Microsoft Excel MVP "Joseph" wrote in message ... My excel's formula is not currently funtioning automatically. An example is when I'm copying a formula to be pasted in multiple cells either any direction, it only gives me the amount that I copied although the formula bar shows the formula copied refers to different cells and values. I also found out that it will only calculate everytime I press F2 and enter. What if I need tens thousands of cells, I cannot afford to do it on every cell. Please help. tnx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formulas will not compute | Excel Worksheet Functions | |||
| Formulas that don't compute | Excel Worksheet Functions | |||
| Formula won't compute | Excel Discussion (Misc queries) | |||
| compute? hmmm. | Excel Discussion (Misc queries) | |||
| How do I compute ratios? | Excel Discussion (Misc queries) | |||
Linear Mode
