Listware for Excel:Best Practices
Upgrade to latest .NET
BP_XLPW_001
NET Framework 4 is required to run Listware. If it is not installed the user is required to install it. Upgrade to the latest "FULL" version of .NET before installing the Excel Plug-ins
Saving Output Results
BP_XLPW_002
As with most applications, it is good practice to periodically save your work. If you have opened a different file type, save as xls or xlsx to be able to save the background colors of the cells and the comments on the fields that the Personator web service appends to your Listware for Excel spreadsheet. Save the active sheet between multiple runs. In the event the service ends unexpectedly, previously appended Results will not be lost.
Optimizing Speed
BP_XLPW_003
For faster processing speed, turn off the PlugIn Options which add formatting to the output cells. While the formatting makes post-processing analyzing easier and visually more attractive, writing the formatting to the excel output sheet can slow down the process significantly. For larger runs on older machines, using these options can also use memory resources than can be allocated resulting in a crash.