XL7: User Name Changes When You Open/Save Shared Workbook

The information in this article applies to:

• Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

In Microsoft Excel, when you share a workbook or open a shared workbook, you receive a User Identification dialog box with the following message:

   Welcome to the Shared List feature in Microsoft Excel.

   Please enter your name below so you can be identified to other users who
   are sharing workbooks with you:

CAUSE

This behavior is by design of Microsoft Excel. When you share a workbook, or open a shared workbook for the first time, Microsoft Excel prompts you for the name that you want displayed as the name of the user that has this workbook open (on the Status tab in the Shared Lists dialog box). However, if you enter a name in the User Identification dialog box that is different from the name in the User Name box on the General tab in the Options dialog box, the name that you enter replaces the User Name value.

If you are using another person's computer, this may not be the desired behavior. The value in the User Name field is used as the default value in the Author box in the Properties dialog box for all new files created in Microsoft Excel.

RESOLUTION

To avoid changing the User Name in this copy of Microsoft Excel, accept the name that appears in the User Identification dialog box when you share a workbook or open a shared workbook for the first time.

To change the User Name value back to the original name, do the following:

1. On the Tools menu, click Options.

2. Click the General tab.

3. In the User Name box, enter the name that you want to be used as the default Author field value in all new files.