PowerPivot File Size Limit in Excel 2013

4 comments

This is more of a note to self as I am constantly self-confusing myself with how much data can be loaded into a PowerPivot model.

Basically, there are two things to consider, version of office one is running and whether a SharePoint deployment option is required.

First, whether one is running a 32 or a 64 Bit version of Excel.  The 32 Bit version can only address 2GB of memory which effectively limits the size of the PowerPivot workbook to about 500-700Mb.  The 64 bit version used to be limited to 4Gb file size in Excel 2010 but in Excel 2013 that limitation has been removed which means that the size of the workbook is no longer limited by the software but rather by the physical configuration of one’s machine.

Unfortunately, should one plan on posting that workbook in SharePoint, the SharePoint size limitation will dictate that only up to a 2GB file can be uploaded.

Here is the link for more information: http://office.microsoft.com/en-us/excel-help/data-model-specification-and-limits-HA102837464.aspx?CTT=5&origin=HA102893837

4 comments on “PowerPivot File Size Limit in Excel 2013”

  1. I have 64-bit Excel 2013 and I cannot open a file larger than 2GB. There error message is:

    An error occurred while loading the file.

    More Details:Failed to retrieve data from datafile#txt. Reason: The query cannot be completed. Either the size of the query result is larger than the maximum size of a database (2 GB), or there is not enough temporary storage space on the disk to store the query result.

    1. From the software perspective, 64 bit version of excel will be able to handle this file, however, you still need to make sure that the hardware is there to support it as well. I just opened a 2GB Power Pivot file on my machine and this file takes up almost 3gb of RAM and there are also some temp files that are created, so you should have some disk space available as well.

      Generally speaking, 64 Bit Excel running on a machine with 8GB of RAM and with 10GB of free disk space should have no problem handling 2gb Power Pivot file. My test machine has 16GB RAM and 1TB solid state hard drive, but I think it is probably an overkill for what you are trying to do.

      Check out this link for more information

      1. I get the same error with 2013 64bit version and 16GB of RAM on a 5GB file so it appears Powerpivot does have a 4GB limitation?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s