Palisade Knowledge Base

HomeTroubleshootingStatTools"Subscript out of range" or "Excel has stopped working" in Stepwise Regression

13.9. "Subscript out of range" or "Excel has stopped working" in Stepwise Regression

Applies to:
StatTools 7.0.0–7.5.1

Trying to do a stepwise regression in StatTools, I fill in the options in the dialog, but when I click OK, I get "Subscript out of range" or "Excel has stopped working."

Under some circumstances, StatTools is not allocating sufficient memory for the steps in the regression, where a given variable could enter and leave the regression multiple times. This is fixed in StatTools 7.5.2.

If you have a current maintenance contract, or if you are currently running StatTools 7.5.0 or 7.5.1, this is a free upgrade. Click Help » Check for Software Updates.

If you have StatTools 7.0.0 or 7.0.1 without a current maintenance contract, please ask your Palisade sales manager for a quote for the upgrade to our current version.

Last edited: 2018-01-17

This page was: Helpful | Not Helpful