XL97: Not All Menu Items Appear for Other Users
ID: Q157768
|
The information in this article applies to:
-
Microsoft Excel 97 for Windows
-
Microsoft Windows NT versions 3.51, 4.0
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 Windows NT, version 3.51 or 4.0, 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:
- On the Start menu, point to Settings and click Control Panel.
- Double-click Passwords. Click the User Profiles tab.
- Click "Users can customize...". Select both check boxes. Click OK.
Additional query words:
XL97 8.00
Keywords : kbsetup xlui xlwinsetup xladdins
Version : WINDOWS:97; winnt:3.51,4.0
Platform : WINDOWS winnt
Issue type : kbprb