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

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.