Recalculating the worksheet

Excel 365 2016 2013 2010 2003
If you are working with huge workbooks that contain a very large number of formulas, functions, and data, you can turn off the automatic recalculation.

Turning off the automatic calculation feature also means that you must remember to manually recalculate the values in the worksheet before you print. To change the recalculation setting, take the following steps:

   1.   Click the Microsoft Office Button ms office 2007 button , and then click Excel Options.

excel 2007 options

   2.   In the Formulas category, under Calculation options, select one of the following Workbook Calculation options:

options Excel 2007
  • Automatic - This is the default setting. It recalculates the entire workbook each time you edit or enter a formula.
  • Automatic except for data tables - This automatically recalculates everything except formulas in a data table (data tables are used to provide a range of data for one formula and function and are used for an advanced Excel feature called "What If Analysis").
  • Manual - This option tells Excel to recalculate only when you say so. To recalculate manually, press the F9 key. When this option is selected, you can turn the Recalculate before save option off or on.

   3.   Click OK.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.

Referencing cells outside the worksheet

Referencing cells outside the worksheet

Formulas can refer to cells in other worksheets-and the worksheets don't even have to be in the same workbook. Excel uses a special type of notation to handle these types of references.
Opening workbooks automatically

Opening workbooks automatically

If you work with the same workbooks every day it will be helpful to open specific workbook files automatically whenever you start Excel. Any workbooks placed in the XLStart folder open automatically.
Protecting spreadsheet elements

Protecting spreadsheet elements

Working with large and complex Excel workbooks, especially when entering large amounts of data, no one is protected from accidental changes in formulas, formats and other spreadsheet elements. But you can protect yourself from too much work on finding and eliminating such errors by protecting the individual spreadsheet elements.