In Microsoft Excel, all currently open documents use the same calculation, regardless of the mode mode in which they are saved.
To help illustrate how to determine the calculation pattern, this article refers to the following hypothetical document:
Saved with this
File name Type of document mode of calculation
------------------------------------------------------
Auto1.xls Workbook Automatic
Manual1.xls Workbook Manual
Auto2.xls Workbook Automatic
The following statement applies to the calculation mode in Excel:
(1) Open the first document using the calculation mode that was last saved. The document opened subsequently uses the same pattern.
For example, if you open Auto1.xls and then open Manual1.xls, the two documents are calculated using automatic
(using the Auto1.xls mode). If you open Manual1.xls and then open Auto1.xls, the two documents use manual calculations.
(2) Change the calculation mode of an open document to change the mode of all open documents.
If
Auto1.xls and Auto2.xls are open, Auto2.xls.
The calculation mode changed to manual also changes the Auto1.xls mode to manual.
(3) Include all worksheets in the workbook using the same calculation mode.
If
Auto2.xls contains three worksheets, and the calculation mode of the first worksheet changes to the hand in the other two tables that will also change the calculated pattern.
(4) If you close all other documents and create a new document, the new document will use the same calculation mode as the previous closing document.
However, if you are using a template, the calculation mode is the pattern specified in the template.
(5) If you have changed the calculation mode in the workbook and saved the file, the current calculation mode will be saved.
If you have changed the calculation mode in the workbook and saved the file, the current calculation mode will be saved.
How to control the calculation mode
All open documents use the same calculation mode. You must perform special steps to process documents that use different calculation modes. For example, if you are using Auto1.xls and you want to open Manual1.xls in manual calculation mode, do any of the following:
Will
Auto1.xls is set to manual calculation mode, Manual1.xls before opening.
Open the Auto1.xls (and any other open document) before closing Manual1.xls.
There are four modes that you can choose from Microsoft Office Excel 2003
And the calculations in earlier versions. These patterns are illustrated as follows:
Automatic, except table Automatic, Manual, save before automatic calculation
In Excel 2007
Microsoft Office and Excel 2010, the four models that are calculated are as follows:
Automatic, automatic data sheet except, Manual, recalculate workbook before saving
For this mode recalculation occurs
When
-------------------------------------------------------------------
Automatic to the
Document. All
Affected parts of the
Document are
recalculated.
Automatic to the
Document. All
Except tables affected parts of the document except
Tables are
recalculated. A table
is recalculated a
Change are made to it.
Manual you press the F9 key, click
Options on the
Tools menu, click the
Calculation tab, and
Click the Calc Sheet
button.
Manual/you press F9, or click Calc
Sheet on the
Recalculate before Calculation tab on the Tools/options menu,
As
Save the as every time to save the file.
Recalculate Active Worksheets
To recalculate the active worksheet, use one of the following methods:
By
SHIFT + F9.
In
In Excel 2003 and earlier, click the Options on the Tools menu, and then click the Calculation tab to calculate the worksheet to calculate the buttons for the active worksheet.
In
Excel 2007 and Excel 2010, click on the calculation sheet on the formula in the menu calculation group.
Recalculate all open documents
If you have all the open documents recalculated, use one of the following methods:
By
F9.
In
In Excel 2003 and earlier, click the Options on the Tools menu, click the Calculation tab, and then click the Recalculation button.
In
Excel 2007 and Excel 2010, click to recalculate all documents on the formula in the menu calculation group.
How to change the calculation mode for Excel 2007/excel 2010
1. Click Microsoft
Office button and then click Excel Options.
2. On the Formula tab, select the mode you want to use for calculation.
How to change the calculation mode in Excel 2003 and earlier versions of Excel
1. Click the Options on the Tools menu, and then click the Calculation tab.
2. In the next calculation click the calculation mode you want to use.