View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Teresa[_2_] Teresa[_2_] is offline
external usenet poster
 
Posts: 2
Default Formulas not updating when add new inputs

Does it reset itself? I was having problems with this
yesterday and today it is working fine and the
calculation option is set to automatic. Why would it
change?
-----Original Message-----
Check your settings when it does not work. In the main

menu go to
Tools-Options and then in the Options Window go to

the "Calculation"
tab. The top of that tab is where you set the

calculation of formulas
and such to "Automatic" if you so choose. If it is

already set to
automatic and is still not working I'd look at the

formulas themselves.


---
Message posted from http://www.ExcelForum.com/

.