 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2007calculation: automatic?
would somebody please tell me how to change the defaut calculation setting inside options to automatic from manual? I can't have this change be permanent, I would like that everytime I open a workbook the setting is defaulted to calculate= automatic. Please, HELP!!! Leo. And reset it to Auto when the file is closed?  SignatureBernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email > would somebody please tell me how to change the defaut calculation setting > inside options to automatic from manual? [quoted text clipped - 5 lines] > > Leo. Yes, I switched it to manual and I can't find a way to set it on auto by default always. > And reset it to Auto when the file is closed? >> would somebody please tell me how to change the defaut calculation [quoted text clipped - 6 lines] >> >> Leo. Tools | Options | Calculations | Automatic doesn't work? ------------ > Yes, I switched it to manual and I can't find a way to set it on auto by > default always. [quoted text clipped - 9 lines] >>> >>> Leo. when I close and reopen the application still stuck on manual. > Tools | Options | Calculations | Automatic doesn't work? > [quoted text clipped - 13 lines] >>>> >>>> Leo. Excel picks up setting from the first workbook that you open in that session--including personal.xls. So open excel Unhide personal.xls (if you have to) (window|Unhide in xl2003) change that setting Hide personal.xls (if you want) Close excel Answer Yes to the "do you wanna save personal.xls" prompt. (Or you'll be doing it again!) > when I close and reopen the application still stuck on manual. > [quoted text clipped - 21 lines] > >>>> > >>>> Leo. SignatureDave Peterson
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.