Excel Err Msg: Input Range Errors when Using Analysis Tools

ID: Q90509

The information in this article applies to:

Microsoft Excel for the Macintosh, version 4.0
Microsoft Excel for Windows, version 4.0

SUMMARY

In Microsoft Excel, you may receive one of the following error messages when using the analysis tools provided in the Analysis ToolPak:

You must specify a valid contiguous input range.

-or-

You must specify a valid contiguous input range for variable 1.

This error occurs with all of the Analysis ToolPak functions if your worksheet name contains an apostrophe or the hyphen symbol. To resolve the problem, save the worksheet as a new name without using any apostrophes or hypens.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel for the Macintosh, version 5.0, and Microsoft Excel for Windows, version 5.0.

REFERENCES

"Microsoft Excel User's Guide 2," version 4.0, pages 14-55

Additional query words: atp tool pack pak linking single quote correlation covariance regression statistics


Keywords          : 
Version           : 
Platform          : 
Issue type        :

Last Reviewed: July 14, 1999