Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X
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
Solved! Go to Solution.
@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):
Are you using Prime or (real) Mathcad?
Luc
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.
@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):
that seems to work. i open the file then immediately click to stop all calcs.
@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.
I am surprised as to the best of my knowledge Prime does not recalculate when a file is opened. It would recalculate only if you force it by pressing F5/9 or if you change something in your sheet (when autocalc is turned on).
Probably I am wrong about that?
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.