| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas do not work
I have added a column in my excel spreadsheet and copied the formulas from
the column next to it. The correct formulas are in the cells, but they aren't working. I have to go into each individual cell and press F2 and enter for them to update. How do I get the cells to automatically update? I have used excel for years and have never had this problem. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formulas do not work
ToolsOptionsCalculation tab, check Automatic
-- Kind regards, Niek Otten Microsoft MVP - Excel "Crystal" wrote in message ... |I have added a column in my excel spreadsheet and copied the formulas from | the column next to it. The correct formulas are in the cells, but they aren't | working. I have to go into each individual cell and press F2 and enter for | them to update. How do I get the cells to automatically update? I have used | excel for years and have never had this problem. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formulas do not work
Tools/ Options/ Calculation
Set to Automatic, not Manual. -- David Biddulph "Crystal" wrote in message ... I have added a column in my excel spreadsheet and copied the formulas from the column next to it. The correct formulas are in the cells, but they aren't working. I have to go into each individual cell and press F2 and enter for them to update. How do I get the cells to automatically update? I have used excel for years and have never had this problem. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas do not work any more ? | Excel Discussion (Misc queries) | |||
| formulas don,t work | New Users to Excel | |||
| Work book formulas | Excel Discussion (Misc queries) | |||
| 3-D formulas... can it work for text too? | Excel Discussion (Misc queries) | |||
| How can I work around the non value (#N/A) when using formulas in. | Excel Worksheet Functions | |||
Hybrid Mode
