Formulas Not Updating

G

Geoff C.

on occasion, formulas are not automatically updating even
though the auto update is turned on. I have to edit the
cell with F2, then hit enter to get the updates. There
must be a fix out there for this? Anyone know? thx!
 
N

Nick

go, TOOLS, OPTIONS and on the CALCULATION tab make sure
the automatic calculations is on.

cheers
nick
 

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

updating formulas 4
Formulas not updating 9
Formulas Not Updating!!! 3
Named range labels in formulas 1
data not updating 2
Refreshing formulas automatically 3
formulas do not work 2
(djn) Excel Not Updating Random Cells 1

Top