Define Menu Item Missing With Bookshelf Integration (150364)


The information in this article applies to:

  • Microsoft Excel for Windows 95
  • Microsoft Office for Windows 95, Standard edition
This article was previously published under Q150364

SYMPTOMS

If you install the Bookshelf Integration component of Microsoft Office Professional with Bookshelf, when you use the right mouse button to click a cell in Microsoft Excel, the Define option may not be available on the shortcut menu.

CAUSE

You may experience this problem if the Bshdef.xla file is not loaded by Microsoft Excel. Although the Office Setup program automatically installs the two other add-ins (Msreftlx.xla and Bshxl.xla) that provide Bookshelf integration with Microsoft Excel, the Office Setup program does not automatically install the Bshdef.xla add-in file into the Msoffice\Excel\Library folder with the other two add-ins. If the Bshdef.xla file is not loaded, then when you click Add-Ins on the Tools menu, the Bshdef.xla add-in is not listed under Add-Ins Available.

RESOLUTION

To resolve this problem, do the following:

  1. If Microsoft Excel is currently running, quit the program.
  2. Copy the Bshdef.xla file from the Msoffice\Books95 folder into the Msoffice\Excel\Library folder.
  3. Restart Microsoft Excel.
  4. On the Tools menu, click Add-Ins.

    The Bshdef add-in should now appear in the Add-Ins Available list.
  5. Click the Bshdef check box in the Add-Ins Available list, and then click OK.
Now, when you select a cell, and you use the right mouse button to click the cell, the Define option appears on the shortcut menu.

MORE INFORMATION

With the integration of Bookshelf and the Microsoft Office programs you can quickly access some Bookshelf components directly from the Office programs. For example, you can select a cell that contains a single word in Microsoft Excel, right-click the cell, click Define on the shortcut menu, and Bookshelf automatically displays the definition of the selected cell. This functionality is also available from within Microsoft Word, but Word does not have the problem with the Define option failing to appear on the shortcut menu.

The following text is taken directly from the Bsreadme.txt file that is in the Msoffice\Books95 folder: 
   DEFINE MENU SUPPORT IN MICROSOFT EXCEL 7.0
   ------------------------------------------

   You can define any word in Microsoft Excel 7.0 with just a click by
   following the procedure below.

   The following directions assume your hard disk drive is drive C;
   that Bookshelf '95 is installed in C:\Program Files\Microsoft Reference
   \Bookshelf 95; and that Microsoft Excel 7.0 is installed in
   C:\Msoffice\Excel.
  1. Make sure you are not running Microsoft Excel 7.0 or Bookshelf '95.
  2. Copy C:\Program Files\Microsoft Reference\Bookshelf 95\bshdef.xla to C:\Msoffice\Excel\XLStart.

    The next time you start Microsoft Excel, you will see the Define item when you right-click on a cell.

    NOTE: This may slow the Microsoft Excel startup time a little.
These directions for installing the Bshdef.xla file will work; however, if you use the steps given in the above "Resolution" section , you have more control over when and if this add-in is loaded by Microsoft Excel.

REFERENCES

For more information about Bookshelf Integration with Microsoft Excel version 7.0, click the Search button in Bookshelf Help and type:

Excel and Bookshelf
Modification Type:MinorLast Reviewed:8/17/2005
Keywords:kbualink97 KB150364
©2004 Microsoft Corporation. All rights reserved.