Article ID: 2755145 - View products that this article applies to.
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.
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.
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:
(https://support.microsoft.com/kb/830287/ )How to create a dynamic defined range in an Excel worksheet
Article ID: 2755145 - Last Review: November 16, 2012 - Revision: 1.0