Microsoft KB Archive/77501

{|
 * width="100%"|

Excel Err Msg: WHATIF.XLA Error Messages
'Article ID: Q77501

Creation Date: 17-OCT-1991

Revision Date: 04-NOV-1994' The information in this article applies to:


 * Microsoft Excel for Windows, version 3.0 and 4.0
 * Microsoft Excel for OS/2, version 3.0

SUMMARY

The following error messages may be returned when running the WHATIF.XLA add-in macro with Microsoft Excel.

For more information about the add-in macros, please refer to Appendix B in the &quot;Microsoft Excel User's Guide,&quot; and search for Macro Library in the on-screen Help for Microsoft Excel.

For version 4.0, more information about the add-in macros is available on page 197 in the &quot;User's Guide 2.&quot; You can also select Search in the on-screen Help menu, type add-in, choose Show Topic, select the topic you desire and choose Go To.

MORE INFORMATION

The error message(s) are:


 * What if model must be a worksheet.
 * Document is in Workgroup editing
 * file_name is not a valid data sheet.
 * No values entered for reference_area
 * No variables set: can't analyze model.
 * variable_name is not a valid name
 * file_name is not a valid data sheet&quot;)
 * Active cell is not a What If variable
 * Cannot find file_name. You must attach a new data sheet to run What If.
 * You must first specify a data sheet using Formula What If.
 * The Model Sheet does not contain all of the necessary variables for a global toggle.

REFERENCES

WHATIF.XLA, Microsoft Excel version 3.0, EXCEL\LIBRARY subdirectory

WHATIF.XLA, Microsoft Excel for the Macintosh, MACRO LIBRARY folder is located in the folder in which you installed Excel.
 * }

-

"THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED &quot;AS IS&quot; 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." '' ©1997 Microsoft Corporation. All rights reserved. Legal Notices.

''

KBCategory: kberrmsg

KBSubcategory:

Additional reference words: 3.0 3.00 4.0 4.00