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.

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.

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.