Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 827276 - Last Review: January 4, 2007 - Revision: 3.2
Template Wizard Add-in May Cause Excel Macro to Run Slowly
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.
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 "Symptoms" section are affected.
Note Any workbook that contains a linked picture will exhibit the same
behavior.
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:
- Start Excel.
- On the Tools menu, click
Add-Ins.
- In the Add-Ins dialog box, click to clear
the Template Wizard with Data Tracking check box.
- Click OK to close the
Add-Ins dialog box.
Microsoft
has confirmed that this is a problem in the Microsoft products that are listed
at the beginning of this article.
For more information about the Template Wizard Add-In for
Excel 2002, visit the following Microsoft Download Center Web site:
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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=214246/
)
HOW TO: Use the Template Wizard with Data Tracking Add-In in Excel 2000
148314Â
(http://kbalertz.com/Feedback.aspx?kbNumber=148314/
)
How to Use the Template Wizard with Data Tracking Add-In
APPLIES TO
- Microsoft Excel 2002 Standard Edition
- Microsoft Excel 2000 Standard Edition
- Microsoft Excel 97 Standard Edition
| kbdownload kbprb KB827276 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate