|
You may discover that once you begin storing thousands - or millions - of
individual iteration data records in your worksheet, your file size becomes
unwieldy. In some cases we have seen Excel file size exceed 15MB simply
from storing a million data records. This can cause sluggish execution,
sluggishness in opening and closing files, and inconvenience in sharing the file
through email, etc.
Therefore it's often useful to clean the simulation output data from the
worksheet before saving the file. Since this is a task we find ourselves
performing repeatedly, we've developed the habit of creating a "Clear Data"
command button next to the "Run Sim" command button in our models:
There's no big magic here - the button is linked to a simple one-line
function...
...but it's a step-saver we frequently find useful.
| 
