 |
 | 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 / Worksheet Functions / August 2005Calculation
Is there a way to make excel stop calculating a formula when it is taking an excessive amount of time? i.e. when running certain pivot tables, if the data is not sorted properly it will take several minutes to run a summary. I would like to be able to stop the calculation, sort and rerun the report. Thanks Set the calculation mode to either "Manual" or "Automatic except Tables". You'll need to press [F9] every time you want to calc the entire workbook. To change the calc mode choose the following from the menus: Tools | Options | Calculation - John I don't think that will do the trick. I want to be able to stop a calculation once it's in process. Eric > Set the calculation mode to either "Manual" or "Automatic except > Tables". You'll need to press [F9] every time you want to calc the [quoted text clipped - 4 lines] > > - John Press the Esc key. That will stop a calculation in progress  SignatureRegards, David Billigmeier > I don't think that will do the trick. I want to be able to stop a > calculation once it's in process. [quoted text clipped - 9 lines] > > > > - John I tried the esc key, but it did not stop the calclulation. > Press the Esc key. That will stop a calculation in progress > [quoted text clipped - 11 lines] > > > > > > - John Try Ctrl+Break, does the same thing. SignatureRegards, David Billigmeier > I tried the esc key, but it did not stop the calclulation. > [quoted text clipped - 13 lines] > > > > > > > > - John For some reason Ctrl+Break works, but esc does not. Mine is not to ask the question why, so I won't. Thanks much for the assistance, Eric > Try Ctrl+Break, does the same thing. > [quoted text clipped - 15 lines] > > > > > > > > > > - John Ya I think Ctrl+Break is more powerful. I use that as a last resort if I see Excel start to crash :-) SignatureRegards, David Billigmeier > For some reason Ctrl+Break works, but esc does not. Mine is not to ask the > question why, so I won't. [quoted text clipped - 22 lines] > > > > > > > > > > > > - John |
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.