How to Calculate a Workbook / Worksheet When the Calculation Mode Is Set to Manual

Once manual calculation mode is engaged, Excel will only recalculate its workbooks when you tell it to. You can recalculate all workbooks by pressing the F9 function key or you can click the Calculate button in the status bar at the bottom left-hand corner of the Excel screen. Note that Shift+F9 can be pressed to only calculate the worksheet that you are on. You can also press the Calculate Now and Calculate Sheet buttons in Ribbon pictured above to perform the same calculations. By the way, looking at this button when a workbook first opens or is being used is a great way to know instantly if the calculation mode has been set to manual. The Calculate button in the Status bar only appears when the workbook needs to be calculated.

Also if you set the calculation mode to manual and save your workbook, that setting will be stored with the workbook so when the file is reopened, Excel reengages manual calculation mode if it is opened first before any other workbooks. This feature can vary depending upon what is open so always check it. Be careful saving workbooks in this mode because many Excel users are not used to seeing the calculation mode disabled and become confused when first encountering it. Also look on the Excel Options dialog box (File / Options) on the Formulas tab for the settings just discussed. There is also a check box on that tab that controls recalculating the workbook before saving if it is in manual calculation mode.

As per the link I showed, you can go to Office Button, click Excel Options, select Formulas and then check Enable iterative calculation. Register To Reply, 04:47 PM #13. To recalculate the formulas in a workbook when calculation is manual, press F9 or Ctrl+ = (equal sign) or select the Calculate Now button (the one with a picture of a calculator in the upper-right corner of the Calculation group) on the Formulas tab (Alt+MB). Excel then recalculates the formulas in all the worksheets of your workbook. Try starting Excel without add-ins to see if the problem goes away. Do one of the following: If you are running Windows 10, choose Start All apps Windows System Run type Excel /safe in the Run box, then click OK. If you are running Windows 8, click Run in the Apps menu type Excel /safe in the Run box, then click OK. Many calculation options (Automatic, Automatic except for data tables, Manual, Recalculate workbook before saving) and the iteration settings (Enable iterative calculation, Maximum Iterations, Maximum Change) operate at the application level instead of at the workbook level (they are the same for all open workbooks).

Where is Excel Options in Microsoft Excel 2007, 2010, 2013, 2016, 2019 and 365?

Familiar way to open Excel Options if you have Classic Menu for Office

If have installed Classic Menu for Office on your computer, you will discover that the classic style drop down menus and toolbar come back into Ribbon under Menus. So you can follow your use habit in Excel 2003 to seek for Excel Options in Microsoft Excel 2007/2010/2013:

Cached

• Click the Tools drop down menu under Menus tab;
• Then you will view the Excel Options item. Click it, and you will enter into Excel Options window.

Figure 1: Open Excel Options window from Classic Menu

Open Excel Options from Excel 2007 Ribbon if you do not have Classic Menu for Office

• Click the Office button at the upper-left corner;
• At the bottom, you will view the Excel Options button. Click it into Excel Options Window.

Figure 2: Excel Options button in Excel 2007 Ribbon

Open Excel Options from Excel 2010/2013/2016/2019 Ribbon if you do not have Classic Menu for Office

Microsoft Excel Formulas With Examples

• Click the File tab jumping into backstage view;
• Then you will view the Options button at left bar. Click it into Excel Options window.

Figure 3: Open Excel Options window from Excel 2010 Ribbon

There is another way to find out the Options button in the backstage view:

• Click the File tab;
• Click the Help button at left bar;
• In the middle pane, you will view the Options button under the Tools for Working With Office.

More Tips for Microsoft Excel 2007, 2010, 2013, 2016, 2019 and 365

Classic Menu for Office

Brings the familiar classic menus and toolbars back to Microsoft Office 2007, 2010, 2013, 2016, 2019 and 365. You can use Office 2007/2010/2013/2016 immediately without any training. Supports all languages, and all new commands of 2007, 2010, 2013, 2016, 2019 and 365 have been added into the classic interface.

Screen Shot of Classic Menu for Excel