XL97: No Info Window in Microsoft Excel 97

Last reviewed: February 18, 1998
Article ID: Q156450
The information in this article applies to:
  • Microsoft Excel 97 for Windows

SYMPTOMS

In Microsoft Excel 97, when you click Options on the Tools menu, and then click the View tab, no Info Window option appears in the View tab.

CAUSE

The Info window feature is not available in Microsoft Excel 97. It is not possible to display the Info window by clicking an option or running a macro.

MORE INFORMATION

In earlier versions of Microsoft Excel, the Info window feature allows you to display a window that contains detailed information about the active cell, such as cell formulas, values, format, and protection status. To display the Info window in Microsoft Excel 5.0 and 7.0, use the following steps:

  1. On the Tools menu, click Options.

  2. Click the View tab.

  3. Select the Info Window check box, and then click OK.

You can also display the Info window in earlier versions of Microsoft Excel with a macro command.

   In this macro language:              Use this command:
   ------------------------------------------------------------------------

   Microsoft Excel version 4.0 (XLM)   =SHOW.INFO()

   Visual Basic for Applications       Application.DisplayInfoWindow = True

NOTE: If you attempt to display the Info window in Microsoft Excel 97 with a macro command, the command does not work, and no error messages appear.

REFERENCES

For more information about the Info window in Microsoft Excel 5.0 or 7.0, click the Index tab in Microsoft Excel Help, type the following text

   info window

Double-click the selected text to go to the "Info Window" help topic, and then click the "What happened to the Info Window?" button.


Additional query words: XL97 97 8.0
Keywords : xlminfo xlui kbui
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbprb


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 18, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.