Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 2459816 - Last Review: November 3, 2010 - Revision: 1.0
Inserting Rows in Excel Tables with Structured References May Take Several Seconds
Consider this scenario: You create a large Excel table, and create calculated columns that utilize Structured References. Then you select a row header and click Insert on the Home Tab. Alternatively, select a row and click Delete. It takes several seconds to insert or delete a row.
The process of updating the cell dependencies takes longer when Structured References are used in calculated columns.
To work around this issue, remove the Structured References, and use cell addresses in your formulas.Â
If you already have a large table utilizing Structured References, you can easily convert them to cell addresses as follows:
- Select any cell in the table, and click on Table Tools Ribbon, Design Tab
- Click Convert to Range, and confirm by clicking Yes on the message box.
- On the Home Ribbon, click Format as Table, and choose your preferred formatting.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
For a description of using Structured References in Excel Tables, see
http://office.microsoft.com/en-us/excel-help/using-structured-references-with-excel-tables-HA010155686.aspx
(http://office.microsoft.com/en-us/excel-help/using-structured-references-with-excel-tables-HA010155686.aspx)
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See
Terms of Use
(http://go.microsoft.com/fwlink/?LinkId=151500)
for other considerations.
APPLIES TO
- Microsoft Excel 2010
- Microsoft Office Excel 2007
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