locked
Open a specific xlsx file in Excel 2013 (x86) when VSTO or COM add-in is loaded in Excel will get an error. RRS feed

  • Question

  • Just open a specific local xlsx file (606 KB with 153 sheets) in Excel 2013 (x86) without the VSTO or COM add-in, the file was opened just fine. 

    When we just even created an empty Excel Add-in VSTO project or an empty COM add-in project without custom code inside, an error message will appear:  

    There isn't enough memory to complete this action. Try using less data or closing other applications. To increase memory availability, consider: 

    - using a 64-bit version of Microsoft Excel. 

    - Adding memory to your device. 

    From VS 2013 when after the above message was shown up before the file was opened, I saw the exception as below:  

     

    First-chance exception at 0x757F3E28 (KernelBase.dll) in excel.exe: 0xE0000002 (parameters: 0x80004004).

    'excel.exe' (Win32): Loaded 'C:\Windows\SysWOW64\DataExchange.dll'. Symbols loaded.

    'excel.exe' (Win32): Loaded 'C:\Windows\SysWOW64\twinapi.appcore.dll'. Symbols loaded.

    The thread 0x178c has exited with code 0 (0x0).

    The thread 0x1634 has exited with code 0 (0x0).

    The thread 0x5ec has exited with code 0 (0x0).

    Once I closed the above error message dialog, the file was opened and more exception was showing in the output window:

    First-chance exception at 0x757F3E28 in excel.exe: Microsoft C++ exception: Roaming::RoamingCacheException at memory location 0x1509F2F4.

    'excel.exe' (Win32): Loaded 'C:\Windows\SysWOW64\winmm.dll'. Symbols loaded.

    'excel.exe' (Win32): Loaded 'C:\Windows\SysWOW64\winmmbase.dll'. Symbols loaded.

    'excel.exe' (Win32): Loaded 'C:\Windows\SysWOW64\devobj.dll'. Symbols loaded.

    First-chance exception at 0x757F3E28 (KernelBase.dll) in excel.exe: 0x000006BA: The RPC server is unavailable.

    'excel.exe' (Win32): Loaded 'C:\Windows\SysWOW64\mlang.dll'. Symbols loaded.

    'excel.exe' (Win32): Loaded 'C:\Program Files\Microsoft Office 15\root\office15\osf.dll'. Cannot find or open the PDB file.

    'excel.exe' (Win32): Loaded 'C:\Program Files\Microsoft Office 15\root\office15\OSFUI.DLL'. Cannot find or open the PDB file.

    'excel.exe' (Win32): Loaded 'C:\Program Files\Microsoft Office 15\root\office15\OSFPROXY.DLL'. Cannot find or open the PDB file.

    First-chance exception at 0x757F3E28 in excel.exe: Microsoft C++ exception: _com_error at memory location 0x0496DFE8.

    First-chance exception at 0x757F3E28 in excel.exe: Microsoft C++ exception: _com_error at memory location 0x0496EC00.

    First-chance exception at 0x757F3E28 in excel.exe: Microsoft C++ exception: _com_error at memory location 0x0496EEAC.

    First-chance exception at 0x757F3E28 in excel.exe: Microsoft C++ exception: AirSpace::DeviceError at memory location 0x0496F2B4.

    First-chance exception at 0x757F3E28 in excel.exe: Microsoft C++ exception: _com_error at memory location 0x0496DFE8.

    First-chance exception at 0x757F3E28 in excel.exe: Microsoft C++ exception: _com_error at memory location 0x0496EC00.

    First-chance exception at 0x757F3E28 in excel.exe: Microsoft C++ exception: _com_error at memory location 0x0496EEAC.

    First-chance exception at 0x757F3E28 in excel.exe: Microsoft C++ exception: AirSpace::DeviceError at memory location 0x0496F2B4.

    First-chance exception at 0x757F3E28 in excel.exe: Microsoft C++ exception: _com_error at memory location 0x0496DFE8.

    First-chance exception at 0x757F3E28 in excel.exe: Microsoft C++ exception: _com_error at memory location 0x0496EC00.

    First-chance exception at 0x757F3E28 in excel.exe: Microsoft C++ exception: _com_error at memory location 0x0496EEAC.

    First-chance exception at 0x757F3E28 in excel.exe: Microsoft C++ exception: AirSpace::DeviceError at memory location 0x0496F2B4.

    First-chance exception at 0x757F3E28 in excel.exe: Microsoft C++ exception: _com_error at memory location 0x0496DFE8.

    First-chance exception at 0x757F3E28 in excel.exe: Microsoft C++ exception: _com_error at memory location 0x0496EC00.

    First-chance exception at 0x757F3E28 in excel.exe: Microsoft C++ exception: _com_error at memory location 0x0496EEAC.

    First-chance exception at 0x757F3E28 in excel.exe: Microsoft C++ exception: AirSpace::DeviceLostError at memory location 0x0496F2B0.

    First-chance exception at 0x757F3E28 in excel.exe: Microsoft C++ exception: _com_error at memory location 0x0496DFE8.

    First-chance exception at 0x757F3E28 in excel.exe: Microsoft C++ exception: _com_error at memory location 0x0496EC00.

    First-chance exception at 0x757F3E28 in excel.exe: Microsoft C++ exception: _com_error at memory location 0x0496EEAC.

    First-chance exception at 0x757F3E28 in excel.exe: Microsoft C++ exception: AirSpace::DeviceLostError at memory location 0x0496F2B0.

    First-chance exception at 0x757F3E28 in excel.exe: Microsoft C++ exception: AirSpace::DeviceLostError at memory location 0x0496F580.

    First-chance exception at 0x757F3E28 in excel.exe: Microsoft C++ exception: _com_error at memory location 0x0496DFE8.

    First-chance exception at 0x757F3E28 in excel.exe: Microsoft C++ exception: _com_error at memory location 0x0496EC00.

    First-chance exception at 0x757F3E28 in excel.exe: Microsoft C++ exception: _com_error at memory location 0x0496EEAC.

    First-chance exception at 0x757F3E28 in excel.exe: Microsoft C++ exception: AirSpace::DeviceLostError at memory location 0x0496F2B0.

    First-chance exception at 0x757F3E28 in excel.exe: Microsoft C++ exception: AirSpace::DeviceLostError at memory location 0x0496F580.

    First-chance exception at 0x757F3E28 in excel.exe: Microsoft C++ exception: AirSpace::DeviceLostError at memory location 0x0496F5F0.

    'excel.exe' (Win32): Unloaded 'C:\Windows\SysWOW64\vm3dum.dll'

    'excel.exe' (Win32): Unloaded 'C:\Windows\SysWOW64\d3d10level9.dll'

    'excel.exe' (Win32): Loaded 'C:\Windows\SysWOW64\cabinet.dll'. Symbols loaded.

    The thread 0x15b0 has exited with code 0 (0x0).

    The thread 0x1354 has exited with code 0 (0x0).

    I have Excel 2013 running on Windows 10 with 4G RAM.  I would like to know why even an empty COM add-in project could cause this error.  

    Thanks,

    Weiqun


    • Edited by Weiqun Wednesday, December 2, 2015 10:04 PM
    Wednesday, December 2, 2015 9:51 PM

All replies

  • Hi Weiqun,

    Based on the error message, the memory on the computer is not enough to create an Excel progress. Please try to follow the KB below to see whether it is helpful:
    How to troubleshoot "available resources" errors in Excel

    >>I would like to know why even an empty COM add-in project could cause this error.  <<

    As the Visual Studio outputs prompts, even an empty COM add-in needs to load lots of DLL into the memory.

    Regards & Fei


    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.

    Thursday, December 3, 2015 5:49 AM
  • Upgrading the RAM to 8GB did not make any difference for this file.  And opening this Excel .xlsx file from File Explorer would either cause Excel 2013 to hang, crash or display the out of memory message.  I will try to install x64 Excel later and retest it.  

    • Edited by Weiqun Thursday, December 3, 2015 11:30 PM
    Thursday, December 3, 2015 7:05 PM
  • Hi Weiqun,

    Did this issue occur only on the specific spreadsheet? If yes, would you mind sharing a sample spreadsheet to help us to narrow down this issue?

    You can try to upload it via OneDrive, and please remove the sensitive information before you upload.

    Regards & Fei


    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.

    Friday, December 4, 2015 2:40 AM
  • I have uploaded the testData.xlsx to https://onedrive.live.com/?id=2D88AC9B0E29C234%21123&cid=2D88AC9B0E29C234.  

    FYI, trying to open the same file in Excel 2010 (X86) did not have any issues.  A similar COM add-in was also used in the Excel 2010.  And the two COM add-in dlls have similar sets of dependencies, e.g. the same version of the .Net Framework but older versions of the Office interop dlls, etc.  So far, only those who are using Excel 2013 encountered this not enough memory error. 

    Friday, December 4, 2015 4:50 AM
  • Hi Weiqun,

    The file was not available to download, please ensure the file was shared successfully. We can share the file via right click the file->Share->Get a link.

    In addition, here is an helpful link about sharing files using OneDrive:
    Share files and folders and change permissions

    Regards & Fei


    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.

    Friday, December 4, 2015 7:20 AM
  • Thank you for your help.  And here is the link:  https://onedrive.live.com/redir?resid=2D88AC9B0E29C234!579&authkey=!ALA9_P2ND7bPvf4&ithint=file%2cXLSX.

    Thanks,

    Weiqun

    Friday, December 4, 2015 2:55 PM
  • Hi Weiqun,

    Thanks for the sample spreadsheet.

    I can reproduce this issue only first time. After I got the memory issue message, the Excel prompt the repair message and then this issue was fixed.

    Since this issue is complex, I suggest that you contacting Microsoft support to raise an incident so that our engineer could work closely with him to identify the root cause and resolve this issue as soon as possible.
    If the support engineer determines that the issue is the result of a bug the service request will be a no-charge case and you won't be charged.

    Please visit the below link to see the various paid support options that are available to better meet your needs.
    https://msdn.microsoft.com/subscriptions/bb266240.aspx
    Regards & Fei


    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.

    Monday, December 7, 2015 6:31 AM
  • Thank you for you help.  I'll do that.  
    Monday, December 7, 2015 4:16 PM