Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formuals not updating after data entry
Tools Options Calculation Automatic
-- Gary''s Student - gsnu200902 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum isn't updating automatically with new data entry | Excel Worksheet Functions | |||
Auto entry of data based on entry of text in another column or fie | Excel Discussion (Misc queries) | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
updating data entry | Excel Discussion (Misc queries) | |||
Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions |