Excel Workbook automatic calculation

[BlueLord 0]

Hy,

To speed up my script i need a way to "deactivate" automatic workbook calculation on excel (to switch in manual).

I work with a big file and when i paste a formula it's take to much time to calculate, i need to deactivate automatic calc. and paste formula's and after that to calculate (switch to automatic).

And my second question is regarding pivot table... whow to generate them?

Thanks in advance!!!

Edited September 20, 2010 by BlueLord

[Juvigy 49]

1 easy way is to put it to manual and then just save the workbook.

It calculates it before save.

[seandisanti 6]

$oEX = ObjAttach("","excel.Application")
$owb = $oEX.ActiveWorkbook
$oAS = $owb.Activesheet
$oAS.EnableCalculation = "False";If this doesn't work, try 0 or -1 instead of false