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

stop REcalculation when opening file

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

 

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.

6 replies

23-Emerald IV
March 1, 2019

Are you using Prime or (real) Mathcad?

 

Luc

Translate
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.

 

Translate
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.
Translate
Werner_E
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.

 

Translate