Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > Runtime Error 6 Share

Runtime Error 6

Excel Help for Runtime Error 6 in Excel Multiple Regression Analysis and Forecasting Template


Forum TopicPost Reply Login

Runtime Error 6

Rate this:
(3/5 from 1 vote)
ConfusedWhen I paste in 10 rows of new data with 4 independent variables (i.e., not that much data), I get Run Time Error 6.  I haven't renamed the worksheets, but I have unprotected them.  How can I fix this problem?

Thanks!!
 Posted by on
 
Replies - Displaying 1 to 4 of 4Order Replies By: Most Recent | Chronological | Highest Rated
Oops
Rate this:
(3/5 from 1 vote)
This error is an overflow error caused by the number of observations exceeding the Integer limit of around 32,000.

We have updated the template to accommodate this and a new version can be downloaded from here.
 Excel Business Forums Administrator
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
I have the same problem with the new template. 4 variables, 22 observations, all observations are integers. I just purchased the template today
 Posted by on
Oops
Rate this:
(3/5 from 1 vote)
This should not be occuring.  Please make sure that there are no repeated independent variables with the same data.

You can send through your template with data by replying to the notification email of this post and attaching it. We will then investigate and resolve the issue.
 Excel Business Forums Administrator
 Posted by on
Fedup
Rate this:
(3/5 from 1 vote)
We isolated this error which arises in Excel 2007 when one of the Input variable data is formatted as Custom format and not numeric. In this case, the program does not recognize the data and causes the Runtime Error 6 to occur. The solution is to format all of the data in the Input sheet as Number.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Runtime Error 6 in the