ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   input not reflected in excel (https://www.excelbanter.com/excel-discussion-misc-queries/82124-input-not-reflected-excel.html)

Nancy

input not reflected in excel
 
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!

Chip Pearson

input not reflected in excel
 
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!




Nancy

input not reflected in excel
 
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!



All times are GMT +1. The time now is 04:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com