how do I interupt excel 2003 calculations?

P

pulvog

In Excel 2003, I have spreadsheets that contain calls to a server. The can
take many hours to calculate. How can I interrupt Excel so I can save the
partially calculated spreadsheet?
 
D

Dave Peterson

Just a guess...

I just hit the escape key to interrupt long calculations in my workbook (no
server involved).

But you may want to toggle this setting:
Tools|options|calculation tab
turn on manual calculation

And if you do go to manual calculation, you may want to clear the "recalculate
before save" box.

But that's just a guess,

Good luck.
 
N

Niek Otten

Anyway, I don't think you can save partially calculated workbooks and
continue calculating at the interruption point later.
 
D

Dave Peterson

But I could interrupt the calculation, save the workbook and then recalculate
(fully) later.
 
N

Niek Otten

Sure!
You might have to (un)check Tools>Options>Calculation>Recalculate before
save, though, to take full effect
 
D

Dave Peterson

I think we're in violent agreement!

<vbg>

Niek said:
Sure!
You might have to (un)check Tools>Options>Calculation>Recalculate before
save, though, to take full effect
Click to expand...
 
Top