View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Formuals not updating after data entry

Maybe it is set for manual calculation. Click on Tools | Options |
Calculation tab and ensure that Automatic is checked. Save the file to
ensure that the settings will be retained, although if you open a
workbook which is set for manual calculation, then any other files
that you open in the same session will inherit that setting.

Hope this helps.

Pete

On Sep 2, 3:53*pm, saltnsnails
wrote:
I have a very large workbook that has identical page formats on several tabs.
*Each page has an employee number, hours, parts completed, etc. *For some
reason recently, my spreadsheets are not updating my time and rate
calculations until after I save the workbook and/or reopen it. *Normally it
calculates immediately. *Any thoughts?
Thanks!
-CRM