View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
[email protected] jcarter7782@email.vccs.edu is offline
external usenet poster
 
Posts: 1
Default Formula in Excel does not work until after I double-click inside c

On Monday, November 30, 2009 at 1:00:01 PM UTC-5, raaaabert wrote:
I get this alot, and Ive searched everywhere for the answer.

No macros or hidden sheets active.
Manual calculation is not on, it is set on Automatic.
I've tried F9 for posterity, with nothing happening.
I've tried CTRL-ALT-SHIFT-F9 also nothing.

The cells Im working on have been imported from an external source, ie they
are not hand entered but I dont think this is the issue.

They are custom format though, i.e. h:mm:ss.
Once I double-click on the cell and hit return the formula works but never
before.

PLEASE HELP!!!!


Got to the Formulas tab
Go to the Calculation Options drop down
make sure that "Automatic" is selected