Calculation option "Automatic" not working.

[Monicasinha]

In my excel sheet, calculation option "Automatic" not working. Only Manual works after I hit enter.
Pls help

 

[James006]

Hi,
If your Excel options are properly configured ...
have you checked your Event macros ?

 

[Monicasinha]

I do not have any Event macros

 

[James006]

In your Quick Access Toolbar, would you have the Calculations Options set to Manual ...?

 

[Monicasinha]

Automatic calculation works when I select iterative calculation. However pls note that circular reference error is greyed out.

 

[James006]

Have you already closed Excel ...

and re-opened it to look into Options>Formulas>Calculation options ....

 

[Monicasinha]

It is 'automatic'

 

[James006]

Sorry ...

But if the File>Options>Formulas ... AND ... in your menu, the Formulas>Calculations Option are both set to Automatic ... cannot help you out any further

 

[MARK858]

Have you got any cells that the formula is looking at where there appears to be a real number, but the cell is formatted as text?

 

[Fluff]

Automatic calculation works when I select iterative calculation.

That suggests that you have a circular reference somewhere, you will need to find it.