I have created one wookbook with many spreadsheets. Many cells in this
workbook are not updating until I click on the individual cell as if to edit
then hit enter, then the cell updates.

I have checked tools, options, calculate, and it "IS" set to auto calculate.

I have seen this before years ago but so not remember the cause.

HELP PLEASE