Saving data

  • Thread starter Thread starter Formula help
  • Start date Start date
F

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
 
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.
 
Back
Top