Excel Err Msg: Input Range Errors when Using Analysis Tools

Last reviewed: February 27, 1995
Article 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

KBCategory: kberrmsg
KBSubcategory:
Additional reference words: 4.00 atp tool pack pak linking single
quote correlation covariance regression statistics

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 27, 1995
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.