Menu
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.
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.
889
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. 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.
Filter Command to Analyze Large Data Sets Another way of analyzing large data sets in Excel is to use the Filter Command. This may help you filter the information based on the criteria you set. First, select your range of the dataset and then go to Home >> Sort & Filter >> Filter After that, you will see the Filter Icon appear in the headers.
More... Less If you’ve opened a file with a large data set in Excel, such as a delimited text (.txt) or comma separated (.csv) file, you might have seen the warning message, " This data set is too large for the Excel grid. If you save this workbook, you'll lose data that wasn't loaded.
A number of years ago datasets could easily be opened and worked with in Excel. There are a number of powerful features in Excel that allow you to clean, standardize, and munge data. However, even the mighty spreadsheet has its limitations.
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.
125
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.
22
As the other answers already show, the limit in the worksheets itself have not changed, it's still 1M rows.
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.
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!
30
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
