I have a bunch of worksheets where the formulas work &
I have a bunch of work sheets where the formulas are not working unless I F2
and then hit enter on the cell.
I have checked tools,options, calculations & it is set to automatic.
The F9 key does not work either.