Excel Formulas Not Updating

I come across a user with a peculiar issue when updating fields in a excel document the formula values would not update automatically. As it turns out this is a super easy issue to resolve. In office 2016 / 365 you just need to go to theĀ Formulas tab and thenĀ Calculate Options. Under that menu item drop down you can set the formula calculation back to Automatic.

Nathan Payne

I am a Husband, Maker, IT Guy, Photographer and Tech Enthusiast. Follow me on my journeys making gadgets and fixing IT. If you want to stay up to date with the things I do be sure to subscribe to my youtube channel https://www.youtube.com/channel/UCq_9LHarvqdJN66TXwtlEOg

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.