Formuals not updating after data entry
 

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

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

Formuals not updating after data entry
 

Tools Options Calculation Automatic
--
Gary''s Student - gsnu200902