DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 2503335 - Last Review: June 18, 2012 - Revision: 4.0

SYMPTOMS

Consider the following scenario:
  • You add an ActiveX control to a Microsoft Excel 2010 workbook.
  • You hide the columns that include the ActiveX control.
  • You save the workbook, and then you close it.
  • You reopen the workbook, and then you unhide the columns that include the ActiveX control.
In this scenario, the ActiveX control does not reappear in the unhidden columns as expected.

RESOLUTION

To resolve this issue, apply the following update:
2475876  (http://support.microsoft.com/kb/2475876/ ) Description of the Excel 2010 hotfix package (excel-x-none.msp): February 22, 2011

Note This hotfix package only prevents this issue from occurring in files that are created after the hotfix is applied. Therefore, any files that have this issue should be rebuilt after the hotfix is applied.

Registry key information

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756  (http://support.microsoft.com/kb/322756/ ) How to back up and restore the registry in Windows

After you install the hotfix package, to have us enable the hotfix for you, go to the "Fix it for me" section. If you prefer to enable the hotfix yourself, go to the "Let me fix it myself" section.

Fix it for me



To enable the hotfix automatically, click the Fix it button or link. Then click Run in the File Download dialog box, and follow the steps in the Fix it wizard.


Fix this problem
Microsoft Fix it 50788


Notes
  • This wizard may be in English only. However, the automatic fix also works for other language versions of Windows.
  • If you are not on the computer that has the problem, save the Fix it solution to a flash drive or a CD and then run it on the computer that has the problem.

Then, go to the "Did this fix the problem?" section.



Let me fix it myself

After you install the hotfix package, follow these steps to enable the hotfix:
  1. Click Start, click Run, type regedit in the Open box, and then click OK.
  2. Locate and then click the following registry subkey:
    HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options
  3. On the Edit menu, point to New, and then click Dword Value.
  4. Type LegacyAnchorResize, and then press ENTER.
  5. In the details pane, right-click LegacyAnchorResize, and then click Modify.
  6. In the Value data box, type 1, and then click OK.
  7. Exit Registry Editor.

Did this fix the problem?

  • Check whether the problem is fixed. If the problem is fixed, you are finished with this section. If the problem is not fixed, you can contact support (http://support.microsoft.com/contactus) .
  • We would appreciate your feedback. To provide feedback or to report any issues with this solution, please leave a comment on the "Fix it for me (http://blogs.technet.com/fixit4me/) " blog or send us an email (mailto:fixit4me@microsoft.com?Subject=KB) .

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

APPLIES TO
  • Microsoft Excel 2010
Keywords: 
kbqfe kbexpertiseinter kbsurveynew kbhotfixallversions kbfixme kbmsifixme KB2503335
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support