I have experienced several instances where a Microsoft Excel cells does not recalculate even though I have calculate set to "automatic" under options. It usually happens on large spreadsheets with many tabs. Also, I do not have any circular references in the spreadsheet. I have f9 to manually recalc, but I have not had any luck. It does however appear to recalc when I save the spreadsheet. Can anyone explain this phenomenon?
Bookmarks