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 have a passion for all things IT. Whether its the latest tablet or phone all the way through to pioneering cloud computing. In my spare time I like to keep myself busy with Cycling and Photography.

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.