3] Show Formulas button is turned ... If so, delete it, and the formula will update. I hope these tips help many of you solve your problem with Excel formulas not updating automatically.