Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 22nd 05, 05:07 PM posted to microsoft.public.excel.worksheet.functions
carl
 
Posts: n/a
Default Interrupting A Worksheet Calculation

Is there a way to stop the calculation in the worksheet ?

Some of my worksheets take a while to calculate and occaisionally I need to
stop them to attend to something else.

Thank you in advance.

  #2   Report Post  
Old November 22nd 05, 06:43 PM posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick
 
Posts: n/a
Default Interrupting A Worksheet Calculation

Carl,

No. Kill the Excel process, or just wait.

HTH,
Bernie
MS Excel MVP


"carl" wrote in message
...
Is there a way to stop the calculation in the worksheet ?

Some of my worksheets take a while to calculate and occaisionally I need to
stop them to attend to something else.

Thank you in advance.



  #3   Report Post  
Old November 22nd 05, 07:18 PM posted to microsoft.public.excel.worksheet.functions
MrShorty
 
Posts: n/a
Default Interrupting A Worksheet Calculation


In my copy of Excel (2002), if I use the mouse or the arrow keys to
select a different cell, it will usually halt calculation (sometimes
there's a delay), put "Calculate" in the status bar, and wait until I
leave the cursor still for short time, then will restart calculating.

If this is a frequent annoyance, you may consider setting calculation
to manual (Tools- Options-Calculation-check manual).


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=487297



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel VBA - Freeze Worksheet Calculation? TheRobsterUK Excel Discussion (Misc queries) 2 September 25th 05 10:17 PM
access my data from my master worksheet while calculation is don. Kannan.Iyer Excel Worksheet Functions 1 April 6th 05 01:23 AM
Copy from worksheet to another x times Union70 Excel Discussion (Misc queries) 0 March 7th 05 09:03 PM
Worksheet Function - Find? DAA Excel Worksheet Functions 2 February 24th 05 04:15 PM
copyright and worksheet protection dow Excel Discussion (Misc queries) 2 January 3rd 05 03:07 PM


All times are GMT +1. The time now is 05:50 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017