I've been looking a spreadsheet with lots of calculated cell values in some 30,000 rows (pushing towards the limit of XL AFAIK). The details are here
http://www.drroyspencer.com/2010/04/sim ... rsion-1-0/ and the 4MB XLS is available for download. The reported concern is that the author
suspects
After running the model many times, eventually the memory cache used by Excel gets filled up (I think), and garbage numbers start to appear. Just close out Excel and re-open it to fix this.
I haven't run up against this in my trials, but I would like to find out more about this memory cache issue.
Some calculated numbers involve generated random numbers e.g.
Code: Select all
=SQRT(-2*LN(RAND()))*SIN(2*PI()*RAND())*$E$4
I remember some issue associated with having to "reseed" random number generating routines to get/keep them working properly. I also seem to recall this being a reported problem with this program. Is "reseeding" still an issue with RAND()?
thanks for any info
Alan