Microsoft KB Archive/157768

= XL97: Not All Menu Items Appear for Other Users =

Article ID: 157768

Article Last Modified on 10/17/2001

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q157768



SYMPTOMS
When you start Microsoft Excel 97, some menu items are not displayed.



CAUSE
This may occur if the following conditions are true:


 * You are not logged on the computer as the user who originally installed Microsoft Excel 97 (either as an individual program or or as part of Microsoft Office 97) on this computer. -and-


 * The computer is running Microsoft Windows NT, Microsoft Windows 2000, or it is running Windows with User Profiles turned on.

For example, if another user installs Microsoft Excel 97 on this computer and you log on, certain menu items, such as "Save as HTML" (on the File menu) and "Report Manager" (on the View menu), may not appear.



WORKAROUND
To add menu items, you must activate the add-ins that provide the missing menu items. To do this:

 On the Tools menu, click Add-Ins.  In the list of available Add-Ins, select the check box to the left of each add-in whose menu item is not displayed:                                       Menu                 Sub Menu Add-In                    Menu    Item                 Item ---

AccessLinks Add-In        Data    MS Access Form Data   MS Access Report Data   Convert to MS Access Analysis ToolPak          Tools   Data Analysis AutoSave                  Tools   AutoSave Bookshelf Integration     Tools   Look Up Reference Conditional Sum Wizard    Tools   Wizard               Conditional Sum File Conversion Wizard    Tools   Wizard               File Conversion Internet Assistant Wizard File    Save as HTML Lookup Wizard             Tools   Wizard               Lookup Report Manager            View    Report Manager Solver Add-In             Tools   Solver Template Wizard with      Data    Template Wizard Data Tracking Web Form Wizard           Tools   Wizard               Web Form  After the add-ins are selected, click OK to close the dialog box.

Each user who logs on this computer may need to repeat these steps the first time they log on and use Microsoft Excel.



STATUS
This behavior is by design of Microsoft Excel 97.



MORE INFORMATION
When you install Microsoft Excel 97 on your computer, if you choose to install any add-ins, they are copied onto your computer and are available for everyone to use.

However, if your computer is running Windows NT or is configured to use User Profiles under Windows, Microsoft Excel 97 stores add-in settings for each user separately. Because of this, only the user who installed Microsoft Excel 97 will have add-ins turned on by default. Other users who log on to the computer and run Microsoft Excel 97 may find that not all add-ins are turned on.

For example: if userA installs Microsoft Excel 97 and chooses to install add-ins, the Setup program will copy the add-ins onto the computer and turn on the add-ins for userA. If userB logs on the computer, userB initially has no settings for Microsoft Excel 97. So, when userB first runs Microsoft Excel 97, not all of the add-ins will load.

Follow the steps shown in the workaround section to eliminate this problem for the current user.

To turn on User Profiles in Windows:


 * 1) On the Start menu, point to Settings and click Control Panel.
 * 2) Double-click Passwords. Click the User Profiles tab.
 * 3) Click "Users can customize...". Select both check boxes. Click OK.

Additional query words: XL97 8.00

Keywords: kbsetup kbprb kbfaq KB157768

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.