Excel not auto calculating formulas. Follow the suggestions below to fix the issue where Excel is not calculating formulas: Enable the Auto-Calculate option. Disable Show Formula option.

Normally, Excel recalculates formulas automatically whenever you change a cell that’s part of the formula. But if you turned off automatic recalculation, you can still do it manually by pressing F9.