Memory Error Allocation Failure in Excel 2016 working with Pivot Table

Question

Hi,

We are facing an issue in an excel working with Pivot table. Please find the error details below.

We have an excel file (.xlsx) of 143 MB and it contains around 57 worksheets. 

We have used Pivot table on a huge dataset and we are getting a system error when we are trying to apply multiple filters on the Pivot table. Here is the screenshot of the error.

System specifications:

Windows Edition: Windows 10 Enterprise

System Type: 64 bit operating system

RAM: 8 GB

Excel Specifications:

Microsoft Excel 2016 MSO (16.0.4639.1000) 32 bit

This is a very high priority issue and it is effecting our regular business. Could you please provide some suggestion to fix the issue.

Thank you !

Answer 1

Hi,

There is no way out.  Large data files and 32 Bit just do not go together.

Okey. Thank you !

The same excel used to work in Windows 2007 with Excel 2010 version. Could you please provide me some idea on this.

Thank you !

And also can you please provide some information about the limitation of using 32 bit excel. Is there any limitation of excel size or how many rows 32 bit can support without any issue ?

Answer 2

Hi,

There is no way out.  Large data files and 32 Bit just do not go together.

Okey. Thank you !

The same excel used to work in Windows 2007 with Excel 2010 version. Could you please provide me some idea on this.

Thank you !

Answer 3

Hi,

There is no way out.  Large data files and 32 Bit just do not go together.

Answer 4

Hi,

You need to install the SKU of MS Excel with a Bit rate of 64 i.e. 64 Bit.  That should hopefully resolve the issue.

Thank you for your response !

Could you please let me know is there any way to fix the issue in Microsoft Excel 2016 MSO (16.0.4639.1000) 32 bit ?

Thank you!

Answer 5

Hi,

You need to install the SKU of MS Excel with a Bit rate of 64 i.e. 64 Bit.  That should hopefully resolve the issue.