Excel 2013 to 2016 calculation problem

[Chris Swadener]

I have a workbook that is used to calculate multiple items over 40 sheets.  On my balance sheet, in excel 2013 I would hit F9 and could see all the calculations take place in the spreadsheet.  The numbers changing rapidly.  I upgraded to Excel 2016 and when I hit F9 I see the calculations happening in the bottom right task bar but my balance sheet doesn't change.  I need to see the changes in real-time like before.  I have checked all my settings side by side and all are the same.  I have tried every variation of alt-Shift-CRTL f9 there is and nothing.  It seems like this should be a check box somewhere saying show the work in the sheet but I can't find it.

Also can add this works correctly on 2010 as well.

Any Ideas?

[#2]

Hi Chris,

It seems that the calculation option in your old version of Excel was in manual mode as below screenshot:

[#3]

Yes, both 2013 and 2016 are in manual mode.  If it is left in automatic it takes forever to load.  I just can't see the calculations in 2016 in the spreadsheet.