Article ID: 2755145 - View products that this article applies to.
Expand all | Collapse all

Symptoms

You try to insert or delete rows in a Microsoft Excel 2013 worksheet. You do this after you sort a range that contains defined names that refer to whole columns. In this scenario, it takes a very long time to insert or delete rows. 

Cause

This issue occurs because of the defined names. There are over one million rows per column in Excel 2013. If you refer to the whole column, all rows of the column are loaded into memory when you perform an operation on the column. Therefore, you encounter a performance issue when you insert or delete rows after sorting. 

Workaround

To work around this issue, create a dynamic defined name on ranges instead of naming the whole column.

For more information about how to create a dynamic defined range in Excel, click the following article number to view the article in the Microsoft Knowledge Base:
830287 How to create a dynamic defined range in an Excel worksheet

Properties

Article ID: 2755145 - Last Review: November 16, 2012 - Revision: 1.0
Applies to
  • Microsoft Excel 2013
Keywords: 
kbprb kbsurveynew kbexpertiseinter KB2755145

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com