Excel-FAQ:1:Automatic Formula Update



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?








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'



  1. gravatar

    # by Anonymous - July 16, 2009 at 11:25 PM

    Thanks Man..although those were not my exact words.. :)

Blog Widget by LinkWithin

Search this blog..

Loading