Calculation option "Automatic" not working.

[Monicasinha]

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

 

[Monicasinha]

Yes, there was a circular reference. Was very hard to find but could finally do it. Thanks!

 

[Alex Blakenburg]

For future reference, there is a macro here that may have helped you find it.
Find circular references within your workbook

 

[Monicasinha]

ok- thank you so much!

 

[James006]

Interesting to have a Circular Reference without any reference at the bottom left corner ...