Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
When I enter info in one of my files, the numbers don't add up/the new
numerical info isn't reflected until I try to close the file, then all my cells update. Any help available? TIA! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
It sounds as if you have calculation set to manual. Go to the
Tools menu, choose Options, then the Calculation tab. There, ensure that 'Automatic' is selected. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Nancy" wrote in message ... When I enter info in one of my files, the numbers don't add up/the new numerical info isn't reflected until I try to close the file, then all my cells update. Any help available? TIA! |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
It certainly was. Thank you!
"Nancy" wrote: When I enter info in one of my files, the numbers don't add up/the new numerical info isn't reflected until I try to close the file, then all my cells update. Any help available? TIA! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
macro security too high in excel, I can not get into input data | Excel Worksheet Functions | |||
Trouble with saving user input in an Excel Form. | Excel Discussion (Misc queries) | |||
How to import a text file to Excel treating all input content are in string. | Excel Discussion (Misc queries) | |||
how to input a calculation in excel to find the geometric mean | Excel Worksheet Functions |