October 2nd 08, 12:21 AMposted to microsoft.public.excel.misc | ||
| ||
F9 Manual Recalculate only for one workbook Press Alt F11. Select the ThisWorkbook module for the VBA project your editing. Paste this in. Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.Calculation = xlCalculationAutomatic End Sub Private Sub Workbook_Open() Application.Calculation = xlCalculationManual End Sub -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. 'Tenacity9' wrote: Setting Tools-Options-Calculation to manual (ie, have to use F9) changes the preference for all open workbooks in Excel 2003. If you only want manual recalculation to apply to a particular workbook permanently (in other words until the preference is changed back to automatic), but other open workbooks and all new workbooks to be calculated automatically (ie, no F9), is there a way to accomplish this easily? Thanks. |
Calculation is the process of computing formulas and then displaying the results as values in the cells that contain the formulas. To avoid unnecessary calculations that can waste your time and slow down your computer, Microsoft Excel automatically recalculates formulas only when the cells that the formula depends on have changed. Excel by default recalculates all formulas in all sheets of all open books after each introduction of data. The most swell possibility of Excel – is the automatic recounting by formulas. If the sheet contains hundreds or thousands of formulas, the automatic recalculation starts to noticeably slow down the process of working with the program. See full list on ablebits.com.
Cached
- Manual Calculation means that Excel will only recalculate when you force it to. This can be with a button press or keyboard shortcut. This can be with a button press or keyboard shortcut. You can also recalculate a single cell by editing the cell and pressing Enter.
- However, this can really slow down your VBA code. It’s a good practice to set your calculations to manual at the beginning of macros and restore calculations at the end of macros. If you need to recalculate the workbook you can manually tell Excel to calculate. Turn Off Automatic Calculations.