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.