Skip to main content
M
mskokan1-Visitor
1-Visitor
February 19, 2025
Question

Does halting and restarting calculations continue the calculation or actually restart it?

  • February 19, 2025
  • 2 replies
  • 514 views

I have a Prime calculation that takes days to run--it's a complicated integration.  If I halt the calculation using the "Stop All Calculations" function on the Calculation tab, save the sheet, then return to that sheet later and re-activate "Auto Calculation" I believe the calculation will continue from where it was halted, even if the file was closed and reopened.  My question is whether or not this halt/save/continue does in fact continue the calculation rather than restarting it.  If I select the "Calculate" option the sheet will definitely start over from the beginning, but that's not what I'm asking about.  I can't submit the sheet due to corporate limitations but the question is general enough someone should have worked it out by now.

2 replies

W
Werner_E25-Diamond I
25-Diamond I
February 20, 2025

As far as I am aware the calculations starts from anew when you restart it after halting it.  Internal intermediate results, etc. are not kept in memory and used when you restart the calculation. This is particularly not the case if you save the sheet and later reload it.

Depending on the kind of calculation you are doing it may be possible that you yourself program your function in a way that it saves intermediate results from time to time using one of the WRITExxxx commands and read them in when you restart the function.

But Prime out of the box won't provide this feature.

 

A
anursinghCommunity Manager
Community Moderator
March 11, 2025

Hi @mskokan,

 

I wanted to see if you got the help you needed.

If so, please mark the appropriate reply as the Accepted Solution. It will help other members who may have the same question.
Of course, if you have more to share on your issue, please pursue the conversation.  

 

Thanks,
Anurag 

Terms & ConditionsCookie settingsAccessibility statement