formulas do not work

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.
 
N

Niek Otten

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refreshing formulas automatically 3
Formulas not copying to other cells 10
Formulas aren't calculating 2
pasting formulas 2
copying groups with formulas 5
Working on multiple spreadsheets at the same time 4
F9 Calc refresh does not work... 3
Paste without overwriting formulas 1

Top