xlCalculationManual does not work?

[pin54]

Hi, at the beginning sorry for my English

My workbook include several worksheets. The main one is named "data" and inside of it I have Worksheet_SelectionChange event. Other worksheet do not contain any makros, only vlookup functions (about several thousands of them).

At the beginning of SelectionChange event I turn on xlCalculationManual. MsgBox Application.Calculation return -4135, so it looks like works correctly...but every time when I change value of any cell in worksheet 'data', excel calculate whole workbook - I think excel do it, because it takes several second to change the value. When I delete all worksheets (besides 'data' of course) everything starts working rapidly.

Please Login or Register  to view this content.

[nathansav]

You turn it back on afterwards

.Calculation = xlCalculationManual
.Calculation = xlCalculationAutomatic

[pin54]

Of course Thanks.
But, is there any possibility to turn on XlCalculationAutomatic but do not calculate workbook in this moment ?

EDIT: never mind, forget about this question, it is stupid idea