I've never had this happen before. I change raw data in a spreadsheet and related calculated cells do not automatically recalculate. They only recalculate after I go into each cell and then into the formula bar and hit enter.
The only thing I can recall that I did recently to this spreadsheet was Check for issues > Inspect workbook. Could that have caused it?
Correct answer - but for us novices - or semi-literate in Excell Click on Formula Tab - Calculate Option on far right of that ribbon and you can change it to Automatic. Something strange is going on with recent updates to Excel 360 - I have multiple spreadsheets that had always auto calculated that stopped doing so. Took me two days to find the way to turn it back on. VERY frustrating. . . .