Microsoft KB Archive/150364

= Define Menu Item Missing With Bookshelf Integration =

Article ID: 150364

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition
 * Microsoft DreamWorks Interactive Small Soldiers: Squad Commander

-



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.
 * 1) 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.

