Worksheet Calc Gets Stopped When Sheet is Clicked

  • Thread starter Thread starter luis.cota
  • Start date Start date
L

luis.cota

The worksheet I'm working with has thousands of formulas, so if the
calculation stops, I need to restart the entire process. If I even
attempt to access a menu item or drag the window around on the screen,
even minimize the window, all calcs stop. Is there anyway to protect
the spreadsheet from being interrupted so easily?
 
I don't think so. In fact, I think many depend on this feature. Instead of
waiting for the calculation process to finish, the user can just go to the next
cell and start inputting more data.

You may want to turn calculation to manual so xl doesn't even try. Then just
recalculate when you want.

Tools|Options|Calculation tab
is where you'd toggle this setting.
 
Thanks for the reply. I do currently have Calc set to Manual. I think
the only way to resolve this is to wrap the calculation within a Macro
- this way I get the window that asks if I want to Stop/Debug/Continue.

Thanks ...
 
If you have calculation set to manual and make a change to a formula in a cell,
then the whole workbook should not be recalculating. I've never seen excel do
that.
 
Back
Top