You type in a function and when you press Enter, the cell displays the actual function text, instead of calculating the function's value.
Use Ctrl-Alt-F9 (instead of the normal F9) to force calculations across the worksheet. Find and replace = with = (equal sign with equal sign) - apparently this can solve the problem.
Sometimes you will certainly add new items into the source range of this name.
However, it is much faster to turn on/off this option using the keyboard shortcut You have a formula that you know you have entered correctly, but when you change the formula, or change the values of its dependent cells the formula continues to show the old value.
This problem is usually caused by the setting of the Calculation option for your Excel spreadsheet.
By Greg Harvey Normally, Excel 2013 recalculates your worksheet automatically as soon you change any entries, formulas, or names on which your formulas depend.
This system works fine as long as the worksheet is not too large or doesn’t contain tables whose formulas depend on several values.
Because Excel recalculates dependent formulas in the background, you can always interrupt this process and make a cell entry or choose a command even when the pointer assumes the hourglass shape during the recalculation process.
As soon as you stop making entries or selecting commands, Excel resumes recalculating the worksheet.
To control when Excel calculates your worksheet, you click the Calculation Options button on the Formulas tab of the Ribbon and then click the Manual option button or press Alt MXM.