[FONT="]I have a worksheet where I am running a mote carlo simulation. It has about 1000 rows. Several of the columns have random numbers in there (rand() and randbetween(0,5)). One Column has binom.inv with rand() for alpha.
[/FONT]
[FONT="]The output is the sum of the final column's 1000 rows.
[/FONT]
[FONT="]Anyway, in order to run this simulation several times I created a data table where the column input cell is a blank cell. It works the first time always.
[/FONT]
[FONT="]However, if I change any of the assumptions it stops calculating correctly. I have tried F9. shift + F9, ctrl + alt + shift f9, all of them. Nothing works. I have it calculation set to manual for convenience, but I have tried automatic and automatic except data table, and the issue remained.
But, if I click save it magically recalculates everything correctly. I am not sure why.
[/FONT]
[FONT="]What is going on? How do I fix it?
Thanks for the help[/FONT]
[/FONT]
[FONT="]The output is the sum of the final column's 1000 rows.
[/FONT]
[FONT="]Anyway, in order to run this simulation several times I created a data table where the column input cell is a blank cell. It works the first time always.
[/FONT]
[FONT="]However, if I change any of the assumptions it stops calculating correctly. I have tried F9. shift + F9, ctrl + alt + shift f9, all of them. Nothing works. I have it calculation set to manual for convenience, but I have tried automatic and automatic except data table, and the issue remained.
But, if I click save it magically recalculates everything correctly. I am not sure why.
[/FONT]
[FONT="]What is going on? How do I fix it?
Thanks for the help[/FONT]