XL2002: Combo Box Control on a Worksheet Displays Its Original Value Instead of the New Value (315199)

SYMPTOMS

A combo box control on a worksheet displays the original value, rather than the new value, after the control loses focus or after you refresh the display. For example, if a combo box is initialized with the value "January" and then you change the selection to "February", the value "January" appears in the combo box after you click out of the combo box control.

RESOLUTION

A supported hotfix is now available from Microsoft, but it is only intended to correct the problem that is described in this article. Only apply it to systems that are experiencing this specific problem. This hotfix may receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next Office XP service pack that contains this hotfix.

To resolve this problem immediately, contact Microsoft Product Support Services to obtain the fix. For a complete list of Microsoft Product Support Services phone numbers and information about support costs, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support

NOTE: In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The typical support costs will apply to additional support questions and issues that do not qualify for the specific update in question.

The English version of this fix should have the following file attributes or later:

   Date          Time      Version      Size       File name     
   -----------------------------------------------------------
   13-DEC-2001   16:55:44  10.0.3612.0  9,169,224  Excel.exe

WORKAROUND

To work around this problem, use either of the following methods.

Method 1

Replace the ActiveX control that you are using with a control from the Forms toolbar. (On the View menu, point to Toolbars, and then click Forms.)

Method 2

Select an alternative method for opening the workbook. For example, open the workbook by using either of the following methods:

On the File menu, click Open.
Use Microsoft Windows Explorer to browse to the file, and then double-click the file icon to open the file.