Skip to main content
1-Visitor
March 1, 2019
Solved

stop REcalculation when opening file

  • March 1, 2019
  • 2 replies
  • 3272 views

hi all, 

my sheet does some calculations and plot the results.  when i reopen the sheet the next day, it has to recalculate everything.  how do i set up the sheet to "save" the previous calculation results?

 

cheers,

blake

 

Best answer by Fred_Kohlhepp

@bsimpkins wrote:

hi, 

i'm using prime 4 but my solutions are not saved when i reopen the file.  i'm doing lengthy fitting routines and when i reopen the file, the fits are redone.

 


You can try (no guarantees):

  • Open Prime as an application, not the file,
  • Turn off automatic calculation,
  • Then open your file.

2 replies

23-Emerald IV
March 1, 2019

Are you using Prime or (real) Mathcad?

 

Luc

bsimpkins1-VisitorAuthor
1-Visitor
March 15, 2019

hi, 

i'm using prime 4 but my solutions are not saved when i reopen the file.  i'm doing lengthy fitting routines and when i reopen the file, the fits are redone.

 

23-Emerald I
March 15, 2019

@bsimpkins wrote:

hi, 

i'm using prime 4 but my solutions are not saved when i reopen the file.  i'm doing lengthy fitting routines and when i reopen the file, the fits are redone.

 


You can try (no guarantees):

  • Open Prime as an application, not the file,
  • Turn off automatic calculation,
  • Then open your file.
25-Diamond I
March 2, 2019

I guess you are using real Mathcad and not Prime as in Prime the results at save time are saved in the file and displayed the next time you open the file anyway.

In real Mathcad you would have to save the states of your calculations yourself.

If a lengthy calculation return a matrix of values you may save this matrix into a file and change your worksheet in the way that the lengthy calculation only is done if this file does not exist, otherwise simply read in the values from the file.