Microsoft KB Archive/107254

From BetaArchive Wiki

Article ID: 107254

Article Last Modified on 6/11/2007


  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel 5.0 Standard Edition
  • Microsoft Query 2000

This article was previously published under Q107254

IMPORTANT: This article contains information about editing the registry. Before you edit the registry, you should first make a backup copy of the registry files (System.dat and User.dat). Both are hidden files in the Windows folder.


You cannot disable ToolTips from within Microsoft Query. If you do not want ToolTips to be displayed, do the following according to the version of Microsoft Query you are using:

Microsoft Query for Windows 95, version 2.0

WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Windows 95. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

For information about how to edit the registry, view the Changing Keys And Values online Help topic in Registry Editor (Regedit.exe). Note that you should make a backup copy of the registry files (System.dat and User.dat) before you edit the registry.

  1. Click the Start button, and then click Run.
  2. In the Open box, type "regedit", without quotes.
  3. Locate the HKEY_CURRENT_USER registry folder.
  4. Expand the HKEY_CURRENT_USER folder until you locate the "SOFTWARE\Microsoft\Query\2.0\Microsoft Query" folder.
  5. Click the Microsoft Query folder.
  6. On the Edit Menu in the Registry Editor, click New, and then click Dword Value.
  7. Type "Tooltips" (without the quotation marks), and then press ENTER.
  8. Click Exit on the Registry menu to exit the Registry Editor.

Using the steps above, the new Tooltips key will be set to 0. When this key is 0, the tooltips will not display in Microsoft Query 2.0. To display the tooltips in Microsoft Query again, either set the Tooltips key to 1 or delete the Tooltips key.

Microsoft Query, version 1.0

Change the MSQUERY.INI file:

  1. If you are in Microsoft Query, quit the application.
  2. Use a text editor, such as Windows Notepad, to open the MSQUERY.INI file (this file should be located in the WINDOWS directory).
  3. In the [Microsoft Query] section of MSQUERY.INI, add the following line:


  1. Save the MSQUERY.INI file and quit the text editor.

When you restart Microsoft Query, ToolTips will no longer appear.

To re-enable ToolTips, remove the "ToolTips=0" line from the MSQUERY.INI file.

Additional query words: MSQuery

Keywords: KB107254