How to Install
Questions and Answers Version History


SensIt Questions and Answers

In Windows Excel, why doesn’t the menu item appear in the Add-Ins ribbon, and why doesn’t the add-in respond to the shortcut key?
In July 2016 Microsoft released a security update which may affect downloaded XLA and XLAM add-in files with Windows Excel. After you load the add-in XLAM file, if the menu item does not appear in the Add-Ins ribbon and the add-in does not respond to the shortcut key, quit Excel. Use your file manager to navigate to the add-in XLAM file on your local drive. Right-click the XLAM file, and choose Properties > General. If there is an option to Unblock, click the checkbox and click OK. Then launch Excel, and use Excel’s File > Open to load the XLAM file, or follow the instructions for installation. For more information, see

In Windows Excel 2007 & 2010 & 2013 & 2016, what is the shortcut key to run SensIt?
Control+Shift+P for SensIt Plot (one input, one output)
Control+Shift+S for SensIt Tornado-Spider (many inputs, one output)

In Mac Excel 2011 & 2016, what is the shortcut key to run SensIt?
Option+Command+P for SensIt Plot (one input, one output)
Option+Command+S for SensIt Tornado-Spider (many inputs, one output)

In Mac Excel 2016, how do I specify cells and ranges in the SensIt dialog box?
Currently the only way is to type the cell or range reference, e.g., B5 or B7:B11. The reference cannot be specified by the usual point-and-click on a cell or by a click-and-drag on a range of cells. The technical explanation is that the RefEdit control for a VBA UserForm does not yet work in Mac Excel 2016.

If you have Mac Excel 2011, we recommend using it instead of Mac Excel 2016. Mac Excel 2011 is a mature, stable product, whereas Mac Excel 2016 is an evolving product. If you must use Mac Excel 2016, be sure to obtain the latest updates.

How do I uninstall TreePlan?
If SensIt has been installed so that it appears in the Excel Add-ins Available dialog box, uncheck the SensIt item and quit Excel. Then move or delete the SensIt XLAM file. The next time you run Excel, respond to the prompts about Excel not being able to find SensIt.

How do I get a refund?
Uninstall SensIt , delete all SensIt files from your storage devices and computer, empty the Trash, and send an email to Mike Middleton <> stating that you have done so and that you request a refund.

In Mac Excel 2011, what can I do if I try to run a VBA add-in (TreePlan, SensIt, or SimVoi) and receive an error message like “Error in loading DLL,” “Excel could not open (the XLAM add-in file name) because some content is unreadable …,” or “Excel repaired or removed unreadable content from this workbook …”
See the discussion on our web page Cannot-run-XLAM-file-in-Mac-Excel-2011.

Back to top


How to Install

1. Immediate Download: After you purchase, SWREG will send a confirmation email message to the email address you specified. If you do not see the email message within several minutes, check your spam and junk folders. The email message contains the URL where you can immediately download the software (as a compressed ZIP file). The download link will expire after 7 days from the time of purchase. Be sure to download the software immediately.

2. Extract from ZIP: After you download the compressed ZIP file from the SWREG web site, right-click (Windows) or double-click (Macintosh) the ZIP file to extract the XLAM add-in(s) and other files.

3. Install XLAM add-in: Delete old versions or any Trial version of the XLA or XLAM files from your computer. Installation is simple but is not automated. Refer to the extracted How-To-Install-Add-In PDF file for detailed installation instructions.

4. Guide: For software details and tutorial, refer to the Guide PDF file(s) extracted from the ZIP file.

5. Questions: If you have any questions, send e-mail to Mike Middleton <>.

Back to top


Recent Version History for SensIt

Release Date
1.53 2016-06-26 Add workaround for Mac negative-valued XY chart axis title bug
Avoid persistent menu item on Windows Add-Ins ribbon
1.52 2016-02-02 Revise Mac Excel 2016 shortcut key reminder message
1.51 2015-03-25 Modify Plot feature to workaround Excel 2013 XY chart problem
1.50 2015-01-31 Improve speed by avoiding screen updates during computations
Repair accommodating identical input values for min, base case, and max
Repair problem updating data labels when tornado chart data are sorted
1.49 2014-09-15 Improve compatibility of one-input charts for some systems
Fix run-time error problem for some Mac non-English formats
1.48 2014-07-11 Change Standard name to Pro with single-line menu items
Improve compatibility of tornado charts for some systems
Fix compile-error problem for some non-English versions
1.47 2014-04-26 Change XLS & XLA files to XLSX & XLAM file formats
1.46 2013-08-19 Improve uninstall of menu item in Excel 2013
1.45 2010-08-21 Accommodate identical input values for minimum, base case, and maximum
Fix problem updating data labels when tornado chart data are sorted
1.44 2009-12-09 Accommodate negative values as inputs for spider charts
1.43 2009-08-19 Add ability to specify step for spider charts
Add two-factor tornado charts
1.31 2009-03-28 Add Percent Swing Squared to tornado charts

Back to top