View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Whois Clinton Whois Clinton is offline
external usenet poster
 
Posts: 38
Default Formula doesn't work unless hit enter again

That was exactly it. Any idea why that happened. I know I didn't
intentionally change that.

"Mike H" wrote:

Sounds like calculation has switched to manual.

Tools|Options|Calculation Tab.

Select automatic.

Mike

"Whois Clinton" wrote:

Hi,
I have the formula below to calculate percentage of gains. It has been
dragged through approximately 70 rows. It has been working fine automaticall
calculating as I enter the data in columns K,L,M. However, today as I
continue entering data the formula does not automatically calculate. i have
to click the cell, place the cursor in the formula bar and then press enter.
i change nothing in the formula, but simply bringing it into formula bar and
pressing enter the formula then works.

Is it a fluke? I have tried reopening it but the problem persists.

Thanks in advance,
Clint



=((M27-K27)*100)/K27