Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-31-2017, 02:29 PM
Steve_B Steve_B is offline set formula calc to manual when opening any workbook Windows 7 64bit set formula calc to manual when opening any workbook Office 2013
Novice
 
Join Date: Jul 2013
Posts: 7
Steve_B is on a distinguished road
Default

If you want a specific workbook to open with calculation set to manual, create this sub in the workbook:

Sub Auto_Open()
Application.Calculation = xlManual
End Sub



It automatically runs when you open the workbook, and sets calculation to manual.

If you want excel to always open with calculation turned off, create personal.xlsb, save it in the correct folder and put the sub in it. You can look up how to setup and use personal.xlsb on the web. I'm not sure why you would set calculation to manual as the default, though.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
force formula calc to manual when opening any workbook johnd23 Excel 1 02-27-2017 08:22 PM
Perform calc in active cell then highlight based on formula result grexcelman Excel Programming 4 01-12-2015 11:00 AM
set formula calc to manual when opening any workbook Trying to create a formula to calc if I add x new accounts, I will have to hire y tech/support ppl glen123 Excel 7 07-28-2014 07:29 AM
Problem opening Workbook with WORD VBA buncs Word VBA 0 01-14-2014 07:16 PM
set formula calc to manual when opening any workbook #REF! error when opening a workbook that contain a refference to another workbook tanababa Excel 2 06-07-2012 03:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:29 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft