Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-27-2017, 11:04 AM
johnd23 johnd23 is offline force formula calc to manual when opening any workbook Windows 10 force formula calc to manual when opening any workbook Office 2016
Novice
force formula calc to manual when opening any workbook
 
Join Date: Feb 2017
Posts: 2
johnd23 is on a distinguished road
Default force formula calc to manual when opening any workbook

hi,
I need to have excel open any existing workbook with formula calculation set to 'manual'. I've added a workbook with manual setting to my xlstart folder, which works great for getting the setting to manual automatically when a user opens a workbook with excel not already open. but the only way I can think of to have excel set the setting to manual when opening any workbook regardless of whether excel is already open or not is to tie the action of manual setting to any 'open' event. or maybe there is another way? please advise. thank you.
- john
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Force save after opening a template based file JonFleming Word VBA 11 03-23-2016 08:45 AM
Perform calc in active cell then highlight based on formula result grexcelman Excel Programming 4 01-12-2015 11:00 AM
force 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
force 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 06:23 AM.


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