COUNTIF not automatically updating?

[luke02]

Hi
I would be very grateful if someone can help me. I have set up drop down menus within a spreadsheet containing various text entries so only a set number of options can be selected. I then have a summary table set up using COUNTIF to count how many times each option is selected so I dont have to do so manually.

This has worked perfectly, however recently I expanded the selection and for some reason the COUNTIF function now only updates when I click in the formula bar and hit 'enter'. (i.e as if I am 'refreshing the formula').

Previously when new options were selected the running total updated automatically, and this is what I would like to continue. Does anyone know why this is happening and how I can ensure it upates automatically?

thanks

 

[Amnesiac]

Double check your settings. Go to Excel options>Formulas>make sure workbook calculation is set to Automatic.

 

[Excelestial]

Is your automatic calculation turned on (from the toolbar FORMULAS menu)?

 

[luke02]

that has solved it. thanks guys!

 

[Jaybopper]

Registered so I could say THAAAAAANKS!!!!