Microsoft KB Archive/315199

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

Article ID: 315199

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q315199



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 &quot;January&quot; and then you change the selection to &quot;February&quot;, the value &quot;January&quot; appears in the combo box after you click out of the combo box control.



CAUSE
This problem occurs when you open the workbook by using a hyperlink. It is caused by differences in the way that Excel opens a file from a hyperlink versus opening a file from a UNC path or a mapped drive.



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.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Keywords: kbhotfixserver kbqfe kbbug kbfix kbqfe KB315199

-

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

© Microsoft Corporation. All rights reserved.