XL2000: Combo Box Control on a Worksheet Returns to Its Original Value After Refresh

Article translations Article translations
Article ID: 311749 - View products that this article applies to.
This article was previously published under Q311749
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

On This Page

Symptoms

A combo box control on a worksheet displays the original value, rather than the new value, after you change the focus from the control to another area of the screen, 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 control after you click out of the control.

Cause

This problem only occurs when you open the workbook by using a hyperlink. Excel opens a file from a hyperlink differently from the way it opens a file from a Universal Naming Convention (UNC) path or a mapped drive.

Resolution

To resolve this problem, obtain the latest service pack for Microsoft Office 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
276367 OFF2000: How to Obtain the Latest Office 2000 Service Pack
The English version of this fix should have the following file attributes or later:
   Date         Time       Size       File name     
   -------------------------------------------------------
   10-DEC-2001  13:04:08   1,848,996  EXCEL_Admin.msp
   10-DEC-2001  12:06:04   4,461,932  EXCEL.msp
				
After the hotfix is installed, the following files will have the listed attributes or later:
   Date           Time     Version     Size       File name     
   ------------------------------------------------------------
   07-DEC-2001   12:40:42  9.0.0.6006  7,159,853  Excel.exe
   07-MAR-2001   12:25:02  2.0.4807.0     86,016  Msstko32.dll
				

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. To display the Forms toolbar, point to Toolbars on the View menu, and then click Forms.

Method 2

Select another way to open the workbook. For example, either of the following methods works correctly:
  • On the File menu, click Open.
  • Use Windows Explorer to find 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.

This problem was first corrected in Microsoft Office 2000 Service Pack 3 (SP-3).
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 311749 - Last Review: October 25, 2013 - Revision: 1.0
Applies to
  • Microsoft Excel 2000 Standard Edition
Keywords: 
kbnosurvey kbarchive kbhotfixserver kbqfe kbbug kbfix kboffice2000presp3fix KB311749

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com