Windows 10, Excel 365 Not Calculating

[MikeDBMan]

I have a spreadsheet full of SUMIFS() functions. In those formulas are a lot of indirect statements. A typical formula is:

=SUMIFS(INDIRECT("'"&$B$2&"'!e:e"),INDIRECT("'"&$B$2&"'!C:C"),D$5,INDIRECT("'"&$B$2&"'!ap:ap"),"COGS OPEX",INDIRECT("'"&$B$2&"'!p:p"),"COSP")

I just upgraded to Win 10 from Win 7 and now my formulas like the one above won't recalc unless I highlight each cell, hit F2 and then hit enter. Calc is set to automatic. Hitting F9 or Calculate now does nothing. HELP. Any suggestions?

 

[arthurbr]

Perhaps set your cells to General instead of Text ?

 

[MikeDBMan]

I changed the format to general and no change. And they are not formatted as text. They are mostly numbers so mostly formatted as currency.