BlueLord Posted September 20, 2010 Share 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 Link to comment Share on other sites More sharing options...
Juvigy Posted September 21, 2010 Share Posted September 21, 2010 1 easy way is to put it to manual and then just save the workbook. It calculates it before save. Link to comment Share on other sites More sharing options...
seandisanti Posted September 21, 2010 Share 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 Link to comment Share on other sites More sharing options...
Fiinguer Posted March 15, 2021 Share Posted March 15, 2021 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? Link to comment Share on other sites More sharing options...
Subz Posted March 15, 2021 Share Posted March 15, 2021 https://docs.microsoft.com/en-us/office/vba/api/excel.application.calculation Link to comment Share on other sites More sharing options...
water Posted March 15, 2021 Share Posted March 15, 2021 @Fiinguer Please do not necro 10 years old threads. Open a new one My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now