一般领域 - excel问题 - excel限制 [英] General area - excel question -- excel limitation

问题描述

我的客户端经常使用excel，尤其是大型数据集。考虑到电子表格包含200,000行，有时会同时删除一组8000行。最初，执行此任务需要2分钟，现在需要10分钟。有时Excel完全停止响应，导致Excel挂起。



升级到这个版本的excel会解决手头的一些问题吗？

Excel 2010性能：性能和限制改进 [ ^ ]





非常感谢任何想法！



谢谢！



我尝试过：



我尝试删除8000行数据一次包含约200,000行的工作表。这导致excel挂起，并要求我重新启动excel程序。

My client works with excel constantly, especially with large data sets. Considering the spreadsheet contains 200,000 rows, sometimes there is a set of 8000 rows deleted at once. Initially, this was taking 2 minutes to perform this task, now it is taking 10 minutes. sometimes Excel completely stops responding, causing Excel to hang.

Would upgrading to this version of excel solve some of the issues at hand?
Excel 2010 Performance: Performance and Limit Improvements[^]


Any ideas is much appreciated!

Thanks!

What I have tried:

I tried deleting 8000 rows of data at one time in a sheet containing about 200,000 rows. This causes excel to hang, and requires me to restart excel program again.

推荐答案

你可以：

1）关闭自动计算之前删除：如何更改Excel 2013中的自动计算和多线程功能 [ ^ ]



2）添加已删除的列并过滤而不是删除该行。



3）尝试使用64位版本的Excel。

You can :
1) Turn off auto calculate before deleting : How to Change the Automatic Calculation and Multi-Threading Features in Excel 2013[^]

2) Adding a deleted column and filtering on that instead of deleting the row.

3) Try a 64bit version of Excel.

这篇关于一般领域 - excel问题 - excel限制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！