Excel Workbook automatic calculation

[BlueLord]

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]

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

It calculates it before save.

[seandisanti]

$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

[Fiinguer]

On 9/21/2010 at 5:35 AM, seandisanti said:

 

$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

 

I Know it has been many years ago lol

Didn't work for me. Any help about it?

[Subz]

https://docs.microsoft.com/en-us/office/vba/api/excel.application.calculation

[water]

@Fiinguer

Please do not necro 10 years old threads. Open a new one