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
|