How Excel determines the description of the current calculation pattern

Source: Internet
Author: User
Tags manual versions

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.