Excel formula updating
The final reason could be that the Show Formulas button on the Formulas tab is turned on.This can easily be done accidentally, or possibly by someone else using this workbook previously. It shows the formula instead of the formula result, stopping them from calculating.When you press F2 and Enter you are, effectively, changing a cell so Excel re-calculates.You might get away with pressing F9 to calculate Regards, TMS Trevor Shuttleworth - Excel Aid I dream of a better world where chickens can cross the road without having their motives questioned 'Being unapologetic means never having to say you're sorry' John Cooper Clarke You can probably call the function on a Selection_Change event.. Volatile might not work because the sheet does not re-calculate when the color is applied..This setting can be changed by macros, or by other workbooks that you may have opened first.
When your Excel formulas are not calculating, or not updating, it can be very frustrating.This can be helpful when troubleshooting formula problems.Simply click the Show Formulas button again to turn it off and the formula will be working.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.