Excel-FAQ:1:Automatic Formula Update
Posted by Analyst in Excel, Excel-FAQ, Excel-Functions
on Jun 8, 2009
This question was asked by a Reader ( His Exact Words):
At work my cells that have formulas just stopped updating when I am working live within the workbook. But if I save the entries I made into the cells exit the program and go back in they update.
Any idea what could cause this?
Any idea what could cause this?
Solution:
In Excel 2003 it's usually changable via TOOLS - OPTIONS - CALCULATION and 'CHECK' "Automatic".
In Excel 2007 Go to FORMULAS>CALCULATION OPTIONS and Check 'Automatic'
Search this blog..
Subscribe To
Posts
Comments
SAS
XCELSIUS
EXCEL
VBA
# by Anonymous - July 16, 2009 11:25 PM
Thanks Man..although those were not my exact words.. :)