Formula cells not updating
Usually, the formulas are automatically updated when the user presses enter or click out of the cell, However, quite recently a lot of reports have been coming in about the program not updating the formulas automatically and the formulas not updating when dragged.
This quick fix can save you from the tedium of re-entering thousands of rows of data.
When entering numerical data in Excel, it helps to format it according to the type of data it is. percentage, currency, date, or text—helps drive consistency and accuracy in displaying and working with your data.
If you know from the get-go what format your data should be in, it’s relatively simple to choose a number format for the entire column before entering your data.
Another common reasons is accidentally formatting the cells containing formulas as text. To check this; click on the cell and check the Number group of the Home tab. Change the format to General using the list provided.
Then re-calculate the formula in the cell by double clicking on the cell and pressing Enter.