Excel function not updating double your dating 1st edition
Select the cell that is not recalculating and, on the Home ribbon, check the number format. When a cell is formatted as Text, Excel makes no attempt to interpret the contents as a formula.
After you change the format, you’ll need to reconfirm the formula by clicking in the Formula Bar and then pressing the Enter key.
Does anyone know why this is happening and how I can ensure it upates automatically?
This can be helpful when troubleshooting formula problems.
This is difficult to notice so can go unrecognised, however it will prevent the formula from calculating. When an apostrophe (‘) is entered before typing in Excel, that tells Excel to store the content as text.
Double click the cell, or edit it in the Formula Bar. This is a common approach to store numbers such as phone numbers as text to retain the leading zeros.
When your Excel formulas are not calculating, or not updating, it can be very frustrating.
Your formulas are the driving force for your spreadsheet.