Microsoft KB Archive/827276

= Template Wizard Add-in May Cause Excel Macro to Run Slowly =

Article ID: 827276

Article Last Modified on 1/4/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 97 Standard Edition

-





SYMPTOMS
If you load the Template Wizard add-in and then you run a Visual Basic for Applications (VBA) macro that makes changes to the cells in your Microsoft Excel workbook, the macro may run very slowly. You may also notice performance degradation when you enter data manually.



CAUSE
This problem may occur if the Template Wizard add-in contains a linked picture. Each time Excel recalculates or data is added to the workbook, the linked picture is updated. As a result, the operations described in the &quot;Symptoms&quot; section are affected.

Note Any workbook that contains a linked picture will exhibit the same behavior.



WORKAROUND
To work around this problem, unload or remove the Template Wizard add-in or remove the linked picture in the workbook. To unload the add-in, follow these steps:
 * 1) Start Excel.
 * 2) On the Tools menu, click Add-Ins.
 * 3) In the Add-Ins dialog box, click to clear the Template Wizard with Data Tracking check box.
 * 4) Click OK to close the Add-Ins dialog box.



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



MORE INFORMATION
For more information about the Template Wizard Add-In for Excel 2002, visit the following Microsoft Download Center Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyID=E01EA3D8-094D-4ED1-88DA-F4B8B2AD28BD&displaylang=EN

For additional information about the Template Wizard Add-In for Excel 2000 and Excel 97, click the following article numbers to view the articles in the Microsoft Knowledge Base:

214246 HOW TO: Use the Template Wizard with Data Tracking Add-In in Excel 2000

148314 How to Use the Template Wizard with Data Tracking Add-In

Keywords: kbdownload kbprb KB827276

-

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

© Microsoft Corporation. All rights reserved.