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.