Share via

Memory Error Allocation Failure in Excel 2016 working with Pivot Table

Anonymous
2018-06-22T17:28:31+00:00

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 !

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

6 answers

Sort by: Most helpful
  1. Anonymous
    2018-06-28T00:39:41+00:00

    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 ?

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2018-06-26T20:24:29+00:00

    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 !

    Was this answer helpful?

    0 comments No comments
  3. Ashish Mathur 101.9K Reputation points Volunteer Moderator
    2018-06-25T23:09:07+00:00

    Hi,

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

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2018-06-25T20:49:09+00:00

    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!

    Was this answer helpful?

    0 comments No comments
  5. Ashish Mathur 101.9K Reputation points Volunteer Moderator
    2018-06-22T23:48:44+00:00

    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.

    Was this answer helpful?

    0 comments No comments