I've been reading in several places that Excel 2013 (64-bit) has the ability to open larger datasets, with more rows than before. Yet, my limits seem to be right at where they were with 2010.
我已经在几个地方阅读了Excel 2013(64位)能够打开更大的数据集，比以前有更多的行。然而，我的极限似乎就在2010年的水平上。
I get the same old error about having more than a million or so rows. I was just curious if anyone was able to get larger data sets to import/open. If so, any steps that you went through might be helpful to all. I've tried on 4 different 64-bit Office 2013 PCs and have had no luck.
我得到了相同的老错误关于超过一百万行。我只是好奇是否有人能够导入/打开更大的数据集。如果是这样，你所经历的任何步骤都可能对所有人都有帮助。我试过4种不同的64位Office 2013个人电脑，但运气不佳。
3 个解决方案
#1
17
The row limit in Excel 2013 is still 1 million except for Pivot Tables and PowerPivot: the only thing 64-bit Excel gives you is the ability to use more than 2 Gigabytes of memory.
除了Pivot表和PowerPivot之外，Excel 2013的行限制仍然是100万行:64位Excel提供的惟一功能是使用超过2g的内存。
#2
2
The row limit in Excel 2013 is still 1,048,576 ( x 16,384 columns). The article you are linking refers to data size, not amount of rows.
Excel 2013中的行限制仍然是1048,576 (x 16,384列)。您所链接的文章指的是数据大小，而不是行数。
#3
2
As the other answers already show, the limit in the worksheets itself have not changed, it's still 1M rows.
如其他答案所示，工作表本身的限制没有改变，仍然是1M行。
What has changed is the amount of data you can handle in Powerpivot. This data can be read into the Powerpivot cache - and modified/extended with the DAX formulas - and aggregated with the pivot tables. However, you cannot "edit" them, as you can with normal Excel data.
改变的是在Powerpivot中可以处理的数据量。这些数据可以读取到Powerpivot缓存中——并使用DAX公式进行修改/扩展——并与pivot表进行聚合。但是，不能像使用普通Excel数据那样“编辑”它们。
Before you were limited by the 2GB/4GB barrier - which already allowed for multiple million rows depending on your dataset. With Excel 2013, this limit is now gone - the only restriction is your machines memory. However, you can still not edit the raw data, only handle (DAX) and aggregate (pivot tables) them!
在您受到2GB/4GB的限制之前——根据您的数据集已经允许了数百万行。使用Excel 2013，这个限制现在已经消失了——惟一的限制是您的机器内存。但是，仍然不能编辑原始数据，只能处理(DAX)和聚合(pivot表)!
#1
17
The row limit in Excel 2013 is still 1 million except for Pivot Tables and PowerPivot: the only thing 64-bit Excel gives you is the ability to use more than 2 Gigabytes of memory.
除了Pivot表和PowerPivot之外，Excel 2013的行限制仍然是100万行:64位Excel提供的惟一功能是使用超过2g的内存。
#2
2
The row limit in Excel 2013 is still 1,048,576 ( x 16,384 columns). The article you are linking refers to data size, not amount of rows.
Excel 2013中的行限制仍然是1048,576 (x 16,384列)。您所链接的文章指的是数据大小，而不是行数。
#3
2
As the other answers already show, the limit in the worksheets itself have not changed, it's still 1M rows.
如其他答案所示，工作表本身的限制没有改变，仍然是1M行。
What has changed is the amount of data you can handle in Powerpivot. This data can be read into the Powerpivot cache - and modified/extended with the DAX formulas - and aggregated with the pivot tables. However, you cannot "edit" them, as you can with normal Excel data.
改变的是在Powerpivot中可以处理的数据量。这些数据可以读取到Powerpivot缓存中——并使用DAX公式进行修改/扩展——并与pivot表进行聚合。但是，不能像使用普通Excel数据那样“编辑”它们。
Before you were limited by the 2GB/4GB barrier - which already allowed for multiple million rows depending on your dataset. With Excel 2013, this limit is now gone - the only restriction is your machines memory. However, you can still not edit the raw data, only handle (DAX) and aggregate (pivot tables) them!
在您受到2GB/4GB的限制之前——根据您的数据集已经允许了数百万行。使用Excel 2013，这个限制现在已经消失了——惟一的限制是您的机器内存。但是，仍然不能编辑原始数据，只能处理(DAX)和聚合(pivot表)!