Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #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
  #2  
Old 02-27-2017, 08:22 PM
macropod's Avatar
macropod macropod is offline force formula calc to manual when opening any workbook Windows 7 64bit force formula calc to manual when opening any workbook Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Please don't post the same question multiple times. This one is duplicated in:
https://www.msofficeforums.com/excel...ening-any.html

You may continue the discussion in the other thread. This thread closed.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Closed Thread



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 09:39 AM.


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