Article ID: 956634 - Last Review: July 29, 2009 - Revision: 3.1

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 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:

Install hotfix 956798.

For more information, click the following article number to view the article in the Microsoft Knowledge Base:
956798 (http://support.microsoft.com/kb/956798/ ) Description of the Excel 2007 hotfix package: August 26, 2008
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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/contactus) .

Back to the top