locked
Excel 2016 Out of memory issues RRS feed

  • 質問

  • I am having problems loading data into Excel 2016. I am trying to recreate workbooks that I currently have running in Excel 2010 but when I try to build the pivot table I get a message that says I am out of memory and need to switch to 64 bit excel. The workbooks range from 25 to 80 MG files in Excel 2010, some are single tabs and some multiple. We do not have VB code, macros, etc in the workbooks. Just a data pull by executing a SQL stored procedure into a pivot table.

    I have tried using Power Query in Excel 2013 as well, but get the same error. I  don't see much compression happening in the data.

    2015年11月18日 14:58

回答

すべての返信

  • Hi Audrey,

    This forum is for Developer discussions and questions involving Microsoft Excel, your issue is more related with Excel Pivot table product feature, I will move this thread to the more related forum.

    Reference: http://social.technet.microsoft.com/Forums/en-US/home?forum=excel

    Thanks for your understanding.

    Best Regards,

    Edward


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    2015年11月19日 7:05
  • Hi Audrey Aulenti-Gray,

    Based on your description, it seems this issue appeared in large size files.

    The error message >>Out of memory<< this is possible in some virtual memory systems but not the physical memory. If there are more such pages than there are pages of RAM available, then you could get an “out of memory” error. I suggest you refer to this article:
    http://blogs.msdn.com/b/ericlippert/archive/2009/06/08/out-of-memory-does-not-refer-to-physical-memory.aspx

    You can also refer to the KB article about your issue in Excel and try these methods and check if they work for you.
    https://support.microsoft.com/en-us/kb/2779852

    About 32bit Excel and 64bit Excel, in any 32bit application there is a 2GB limitation. If you work with extremely large data sets, the 64-bit version of Office may perform better for you.

    Hope it's helpful.

    Regards,

    Emi Zhang
    TechNet Community Support


    Please mark the reply as an answer if you find it is helpful.

    If you have feedback for TechNet Support, contact tnmff@microsoft.com.
    2015年11月20日 5:48
  • I just shut down excel, then reopen it in safe mode, shut it down again and open it back up as usual.  Not sure why it works but it does.  Have had to it twice in the last 6 months.
    2019年5月22日 23:29