locked
Excel 2013 / PowerPivot (32 bit) out of memory error RRS feed

  • Question

  • Hello,

    In my data model I have a table which has 6 columns and 133,275 rows. I am frequently getting out of memory errors when I try to analyse the data using my pivot table. The only way to get around this is to close the workbook and open it again. But, as you can imagine it is frustrating and not ideal for exploring the data.

    I am using 32 bit version of Excel, but shouldn't Excel/PowerPivot be able to cope with this number of rows?

    My machine spec is:
    64 bit Windows 7 Enterprise
    32 GB RAM
    20 Cores (Intel Xenon CPU E5-2660 @ 2.20 GHz)

    Thanks in advance...


    • Edited by amir tohidi Tuesday, April 26, 2016 11:45 AM Added machine machine details
    Tuesday, April 26, 2016 11:38 AM

Answers

All replies