formulas do not work

  • Thread starter Thread starter Crystal
  • Start date Start date
C

Crystal

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.
 
Tools>Options>Calculation tab, check Automatic

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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.
 
Back
Top