Saving data

[Formula help]

I have formulas on a worksheet. I also have a Monte Carlo add-in that will
run simulations. When I close the worksheet (workbook) with a given set of
data and the reopen the workbook, a new set of data is shown. This is because
the formulas are initiated when the workbook is open and a new set of data is
generated. I would like to close the workbook and reopen it with the same
data. In other works, I would like to "lock" the date such that it does not
change when I close the workbook and then reopen it.

Any suggestions?

Thank you,

Bill

 

[Shane Devenshire]

Hi,

It sounds like this is the add-in's behaviour, not Excels', in which case
you should look at the add-in.

You might consider copying the results of the simulation to a new range in
the spreadsheet before you save the file.