Can I use large datasets with Excel 2013?

Question

I read in several places that Excel 2013 (64-bit) has the ability to open large datasets , with more rows than before. However, my limitations seem to be correct where they have been since 2010.

I get the same old error that you have over a million lines. I was just curious if anyone could get large datasets for import / open. If so, any steps you have taken may be useful to everyone. I tried on 4 different 64-bit Office 2013 computers and no luck.

Answer 1

The row limit in Excel 2013 is still 1 million, with the exception of Pivot Tables and PowerPivot: the only thing that gives 64-bit Excel is the ability to use more than 2 gigabytes of memory.

Answer 2

The row limit in Excel 2013 is still 1,048,576 (x16,384 columns). The article you link refers to the size of the data, not the number of rows.

Answer 3

As other answers already show, the limit in the sheets themselves has not changed, it is still 1M lines.

The amount of data that you can process in Powerpivot has changed. This data can be read into the Powerpivot cache and modified / extended using DAX formulas and combined with pivot tables. However, you cannot “edit” them as you can with regular Excel data.

Before you were limited by a 2 GB / 4 GB barrier, which already allowed several million rows, depending on your data set. With Excel 2013, this limit is now gone - the only limit is the memory of your computers. However, you still cannot edit raw data, only process it (DAX) and pivot (pivot tables)!