Microsoft KB Archive/151318

Microsoft Knowledge Base

Regression Error: "Output Range Must be a Valid Reference"

Last reviewed: September 13, 1996
Article ID: Q151318

The information in this article applies to:

• Microsoft Excel for Windows 95, version 7.0
• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for the Macintosh, versions 5.0, 5.0a

SYMPTOMS

In the Microsoft Excel products listed at the beginning of this article, when you use the Regression tool that is provided with the Analysis Toolpak, you may receive the following error message:

   Regression - Output Range must be a valid reference.

CAUSE

The error occurs if the name of sheet referenced for the output range contains a space character.

WORKAROUND

To workaround this problem, rename the worksheet so that the worksheet's name does not contain a space character. Once you've completed the Regression, the worksheet can be renamed so that the name contains a space character.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

KBCategory: kbusage kberrmsg KBSubcategory: Additional reference words: 5.00 5.00a 5.00c 7.00 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: September 13, 1996 ©1997 Microsoft Corporation. All rights reserved. Legal Notices.