xlCalculation Method

[sgmpatnaik]

Hi Good Afternoon All


After Long time i got another problem that is Workbook.Calculation Method


I have a workbook which is nearly 20Mb of xlsb format i have lot of sheets are there using with Macro, Formulas and More


while using the above methods my workbook will take 30mnts to open and save so what i did


i gave a code like

[pre]

Private Sub Workbook_Open()
Application.Calculation = xlCalculationManual
Application.CalculateBeforeSave = False
End Sub

Private Sub Workbook_BeforeClose()
Application.Calculation = xlCalculationAutomatic
End Sub

[/pre]

with that code i got speed up of my workbook but there is one problem that is when i open another workbook then that workbook calculation is also set in to manual. When i press the F9 button for calculate then it's calculate both open files which is take the long time for calculate


Is there any chance to set the calculation method to set the manual for the particular workbook


Thanks


SP

 

[vasim]

Well, when I'm stuck in such scenarios, I prefer opening a new excel application and open the second spreadsheet within this application.

 

[sgmpatnaik]

@Indian


Thanks for your response lets see what is replay comes from our Ninja's


Thanks


SP