Force a global recalculation
Q. I find that sometimes my formulas do not get fully calculated. This often happens when I use custom functions created with VBA.
Microsoft has acknowledged some problems with the Excel calculation engine in some version of Excel. In order to be assured that all of your formulas have been calculated, press Ctrl-Alt-F9 to force a complete recalculation.
This key combination will also update formulas that use custom VBA functions.