Version: Office for Mac 2008 (12.2.4)
Formula Cell CR12:
=SUMIFS($N12:$CN12,$N$10:$CN$10,CR$10,$N$9:$CN$9,"x")
Cell P12 Formula:
=VLOOKUP(M12,'US Model Qty'!E:AD,23,0)
When I change data in the "US Model" sheet, cell P12 is Auto Calculating as expected. However, cell CR12 is holding the old (unrefreshed) data. I am able to force the data to refresh by double clicking in cell CR12 and pushing enter on the keyboard.
Does anyone have any idea what would be causing the cell to not Automatically Calculate the data in cell CR12 (yes, the Excel calculation preference is set to Automatically).
Formula Cell CR12:
=SUMIFS($N12:$CN12,$N$10:$CN$10,CR$10,$N$9:$CN$9,"x")
Cell P12 Formula:
=VLOOKUP(M12,'US Model Qty'!E:AD,23,0)
When I change data in the "US Model" sheet, cell P12 is Auto Calculating as expected. However, cell CR12 is holding the old (unrefreshed) data. I am able to force the data to refresh by double clicking in cell CR12 and pushing enter on the keyboard.
Does anyone have any idea what would be causing the cell to not Automatically Calculate the data in cell CR12 (yes, the Excel calculation preference is set to Automatically).
