It seems that when the data in his worksheet changes, the SUMIF function doesn't automatically update.
He is, however, able to update the formula if he selects it, presses F2 (to jump into edit mode) and then press Enter.
Not sure if its just my computer yet, currently testing the issue with different computers.
Johan wrote about a problem he was having with the SUMIF function in his worksheet.
It's not unusual for us to run a model that references back to 20 other Excel files.
Anyway, I put together a pretty simple spreadsheet where a single cell will reference one other file, very simple.
The default setting in Excel 2013 causes your formulas to update automatically, so you are probably accustomed to changing values in cells as needed, without considering that Excel may not be automatically updating related formula cells.
The steps in this article are going to show you how to re-enable the setting in your Excel 2013 worksheet which makes your formulas update automatically.
When updating an Excel spreadsheet formulas do not update automatically as values are entered or updates.
Instead the formula only updates after the formula is edited or the spreadsheet is closed and opened again.
So I closed out of my work so my boss could review.
He told me the model did not update, so I checked it out.