Hi Guys,

I'm building a simplish spreadsheet but one of my cells isn't auto calculating.

The cell in question has a formula
=DATEDIF($J$2,$H$6,"Y")

If i put dates in both J2 and H6, I have to either edit the formula cell and re-press enter or use CTRL+ALT+F9 (F9 and Shift+F9 Do Nothing)
There are four of these in each row and all 4 have this issue


Other cells not using this formula are auto calculating fine
Ribbon > Formulas > Calculation Options are set to automatic
Settings Page Seems Fine
The cells are set to number format

Any Ideas?

P.S. Grr, just tested in a clean sheet and works fine

P.P.S Yep. Just rebooted and working fine. Grr. Argg. WOOF!

Anyone else notice the many bugs occurring with excel lately? I seldom use it but when i do theres always something going on like the above, or scrolling doesn't work. Just me?