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!
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.comquot;Nancyquot; gt; wrote in message
...
gt; When I enter info in one of my files, the numbers don't add
gt; up/the new
gt; numerical info isn't reflected until I try to close the file,
gt; then all my
gt; cells update. Any help available? TIA!
It certainly was. Thank you!
quot;Nancyquot; wrote:
gt; When I enter info in one of my files, the numbers don't add up/the new
gt; numerical info isn't reflected until I try to close the file, then all my
gt; cells update. Any help available? TIA!
- May 16 Wed 2007 20:37
input not reflected in excel
close
全站熱搜
留言列表
發表留言