Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculations
Is there a way to set Excell to automatically update calculations is most
workbooks, but be set as manual in others? |
#2
|
|||
|
|||
Josh
Since Excel takes the calculation mode from the first workbook opened during a session, the only sure way to set calculation mode for a particular workbook would be through code that runs when a workbook is opened or activated. Private Sub Workbook_Activate() Application.Calculation = xlCalculateManual Application.Calculation = xlCalculationAutomatic End Sub Private Sub Workbook_Open() Application.Calculation = xlCalculateManual Application.Calculation = xlCalculationAutomatic End Sub Gord Dibben Excel MVP On Mon, 14 Feb 2005 13:55:14 -0800, "Josh O." wrote: Is there a way to set Excell to automatically update calculations is most workbooks, but be set as manual in others? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculations from data in other worksheets | Excel Worksheet Functions | |||
Format a worksheet to carry out all calculations to 2 decimal plac | Excel Discussion (Misc queries) | |||
Format a worksheet to carry out all calculations to 2 decimal plac | Excel Discussion (Misc queries) | |||
How can I format a worksheet to carry out all calculations to 2 d. | Excel Discussion (Misc queries) | |||
Can you enter a formula in a cell that auto-inputs calculations a. | Excel Worksheet Functions |