how do I interupt excel 2003 calculations?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Anyway, I don't think you can save partially calculated workbooks and
continue calculating at the interruption point later.
 
But I could interrupt the calculation, save the workbook and then recalculate
(fully) later.
 
Sure!
You might have to (un)check Tools>Options>Calculation>Recalculate before
save, though, to take full effect
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Optimising calculation time 11
SAP export to Excel 2003 1
Code Execution Message 1
Turn off "CALCULATE" on bottom of Excel worksheet. near "Ready" 2
Calculate message 1
how do I stop re-calculated fields in excel from going "black" 1
Refreshing formulas automatically 3
Excel Excel Formula - IF Function with percentages 1

Back
Top