CODEWITHSUNDEEP
excel-201032-bitpowerpivotsql-server-2008r2-express
Pho
Pho

Reputation: 108

Memory error: Allocation failure : Excel Powerpivot Add on

The table I am trying to refresh using the Excel 2010 PowerPivot add on is currently 2,670,634 rows, and approximately 473 MB when I export the query results from SQL server into a CSV file format. The operating system is in 64bit but my installed Excel + Powerpivot add on are both 32bit.

I get the Memory error: Allocation failure when I refresh my PowerPivot to retrieve the entire table. At the last PowerPivot refresh, I was able to get 2,153,464 rows into PowerPivot. But today I am unable to refresh and always get the memory error. I am a bit confused by this. I thought I have yet to exceed the max row limit of PowerPivot 2010? I thought that the row limit was 1,999,999,997. What can I do to make it work in 32bit Excel?

Thank you in advance for your tips.

Upvotes: 1

Views: 6010

Answers (1)

Greg
Greg

Reputation: 4055

PowerPivot on 32bit can be a memory hog, requiring about a 1 GB or so of memory. So given how much memory you have available, you can easily run into memory allocation issues with PowerPivot. If you can't use 64bit version, then for starters, simplest thing is to continue to filter the data - reduce the number of rows, reduce the number of columns. After that, you'll have to look at the calculations and such being done, the more rows/data you have, the more expensive it can get.

Upvotes: 2

Related Questions