BlueLord 0 Posted September 20, 2010 (edited) 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 Share this post Link to post Share on other sites
Juvigy 49 Posted September 21, 2010 1 easy way is to put it to manual and then just save the workbook. It calculates it before save. Share this post Link to post Share on other sites
seandisanti 6 Posted September 21, 2010 $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 Share this post Link to post Share on other sites