If Excel Formulas are not working, updating or calculating automatically, here are the working solutions that are sure to resolve the problem for you.

Use the Repair Feature to Recover a Corrupted Workbook Typically, when you open a corrupt workbook, Excel automatically attempts to repair it and displays a dialog box offering the option to ...

If Excel is not highlighting cells in the formula, enable 'Allow editing directly in cells' and 'Enable fill handle and cell drag-and-drop' in Excel options.