Can large datasets be used with Excel 2013?

excel bigdata excel-2013
Chris J. Vargo picture Chris J. Vargo · Feb 11, 2013 · Viewed 41.7k times · Source

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.

Answer

Charles Williams picture Charles Williams · Feb 11, 2013

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.

Related questions

Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More
IF statement: how to leave cell blank if condition is false ("" does not work)

I would like to write an IF statement, where the cell is left blank if the condition is FALSE. Note that, if the following formula is entered in C1 (for which the condition is false) for example: =IF(A1=1,B1,"") …

Read More
'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

I'm trying to get data from an Excel file on a button click event. My connection string is: string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\source\\SiteCore65\\Individual-Data.xls;Extended Properties=Excel 8.0;"; When I click on the button, …

Read More