Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. When you use a macro to automatically write and format data in an Excel 2007 workbook, the macro runs slowly

When you use a macro to automatically write and format data in an Excel 2007 workbook, the macro runs slowly

View products that this article applies to.

Problem description

When you use a macro to automatically write and format data in a Microsoft Office Excel 2007 workbook, the macro runs slowly. The macro runs slower if the workbook has shapes. The macro runs especially slowly when the placement property of the shapes is not set to XLMoveAndSize.

To have us fix this problem for you, go to the "Fix it for me" section. To fix this problem yourself, go to the "Let me fix it myself" section.

↑ Back to the top

Steps to solve the problem

To fix this issue, install hotfix 956798, and then enable the hotfix package. To do this, follow these steps:
  1. Install hotfix 956798.

    For more information, click the following article number to view the article in the Microsoft Knowledge Base:
    956798 Description of the Excel 2007 hotfix package: August 26, 2008
  2. Enable the hotfix package.

    Fix it for me

    To fix this problem automatically, click the Fix it button or link. Click Run in the File Download dialog box, and then follow the steps in the Fix it wizard.


    Fix this problem
    Microsoft Fix it 50144


    Note this wizard may be in English only; however, the automatic fix also works for other language versions of Windows.

    Note If you are not on the computer that has the problem, you can save the automatic fix to a flash drive or to a CD, and then you can run it on the computer that has the problem.

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

    Let me fix it myself

    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 How to back up and restore the registry in Windows


    To fix this issue yourself, follow these steps:
    1. Click Start, and then click Run.
    2. In the Open box, type regedit, and then click OK.
    3. Locate and then click the following registry subkey:
      HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options
    4. On the Edit menu, point to New, and then click DWORD Value.
    5. Type EnableFastTxLink, and then press ENTER.
    6. Right-click EnableFastTxLink, and then click Modify.
    7. In the Value data box, type 1, and then click OK.
    8. On the Registry menu, click Exit.

↑ Back to the top

Did this fix the problem?

Check whether the problem is fixed by using a macro to automatically write and format data. If the macro runs at a regular speed the problem is fixed and you are finished with this article. If the problem is not fixed, you can contact support.

↑ Back to the top

Keywords: KB956634, kbprb, kbqfe, kbexpertiseinter, kbfixme, kbmsifixme, kbsurveynew

↑ Back to the top

Article Info
Article ID : 956634
Revision : 4
Created on : 10/9/2011
Published on : 10/9/2011
Exists online : False
Views : 297