• Skip to main content
  • Skip to primary sidebar

Ravi Shankar

Tweaking Apps

  • Swift
  • Tech Tips
You are here: Home / Excel / How to turn off auto calculation in Excel

How to turn off auto calculation in Excel

October 2, 2015 By Ravi Shankar Leave a Comment

In this tutorial, we will see how to disable auto calculation in Excel 2016, 2013 & 2010. Auto calculation in Excel is an useful feature which would automatically recalculate results based on the changes to the input values. But if you want to temporarily disable this option then you can use the settings available as part of the Formulas Ribbon menu.

Step 1: Launch Excel Application and click the Formulas menu.

image

Step 2:  Navigate to the Calculation section and click on the Calculation Options.

image

Step 3: Select Manual from the Calculation Options drop down list.

Now when ever user makes any changes to excel cell values and if any formula is based on these input cells then the result will not be automatically recalculated.

There is also an option available to do manual recalculation.  Navigate to the Calculation section and click the Calculate Sheet available next to Calculation options.

image

Filed Under: Excel, Excel 2010, MS Office, Office 2010

Reader Interactions

Trackbacks

  1. How to enable or disable multi threading feature in Excel says:
    September 9, 2014 at 8:12 am

    […] Also See: How to turn off auto calculation in Excel 2010 […]

    Reply

Leave a Reply Cancel 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.

Primary Sidebar

TwitterLinkedin

Recent Posts

  • How to set preferred Wifi network on Mac
  • Attribute Unavailable: Estimated section warning before iOS 11.0
  • How to recover Firefox password from Time Machine backup
  • Show hidden files and folders on Mac
  • How to request a refund for apps in App Store

Pages

  • About
  • Privacy Policy
  • Terms and Conditions

Copyright 2022 © rshankar.com

Terms and Conditions - Privacy Policy