Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

EXCEL ? - functions not happening on the fly

Old 12-28-06, 06:18 AM
  #1  
DVD Talk Limited Edition
Thread Starter
 
A-aron's Avatar
 
Join Date: Apr 2002
Location: Formerly known as achau9598 - Baltimore, MD
Posts: 5,717
EXCEL ? - functions not happening on the fly

I have an excel spreadsheet that contains a number of SUM functions. The problem I have is that these functions are not being executed on the fly, but only after I enter the data and click the SAVE icon.

Can someone suggest what might be the problem here?

Thanks in advance.
A-aron is offline  
Old 12-28-06, 07:50 AM
  #2  
Senior Member
 
Join Date: Jun 2001
Location: dc-md-va
Posts: 959
Did you check under Tools, Options, Calculate to see whether Automatic or Manual is checked?
dleedlee is offline  
Old 12-28-06, 07:51 AM
  #3  
DVD Talk Limited Edition
Thread Starter
 
A-aron's Avatar
 
Join Date: Apr 2002
Location: Formerly known as achau9598 - Baltimore, MD
Posts: 5,717
that is it ... thank you very much! I've never needed to look there, and the manual "calc before save" was checked.
A-aron is offline  
Old 12-28-06, 12:11 PM
  #4  
DVD Talk Hall of Fame
 
Blake's Avatar
 
Join Date: Feb 1999
Location: Orange
Posts: 7,736
Just hit F9 to calc also if you want to keep it on Manual.
Blake is offline  
Old 12-28-06, 06:01 PM
  #5  
DVD Talk Legend
 
Join Date: Feb 2003
Posts: 14,204
By the way, CTRL-~ (top-left corner of the keyboard) will also toggle you back and forth. Good to know if:

A) you want to know how this setting got accidentally changed, or

B) you want to screw with a coworker
NCMojo is offline  

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Thread Tools
Search this Thread

Archive Advertising Cookie Policy Privacy Statement Terms of Service

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.