locked
APP HANG on EXCEL using windows 7 RRS feed

  • Question

  • Getting the error below when I open excel files with macros in them...not all files cause a problem but I feel like its a memory crunching issue?

    Problem Event Name: AppHangB1 

    Application Name:   EXCEL.EXE

    Application Version:            14.0.7135.5000

    Application Timestamp:      542ecc22

    Hang Signature:      8aab

    Hang Type:   524

    Tuesday, December 9, 2014 10:59 PM

Answers

  • Hi Chland1214,

    Please try the following two methods to have a check .

    1. Disable add-in and open the files .

      In Excel, click on File<Options< Add-ins.

    Under Manage select COM Add-ins.

      Click on GO options beside Manage, uncheck all the add-ins and click Ok.

    2. Open excel file in safe mode. If it still crashed, copy the content of your excel file to a new workbook to check the issue. When it worked fine in safe mode, do a repair for Office in Control panel>Program and features>Office Version >Change>Repair.

    To open excel in safe mode:

    Click on Start< All Programs< Accessories< Run

    In Run window and type Excel /safe

    Note: There is a space between Excel and /.

    If the issue persists , I agree with Arnav Sharma. The technet excel forum will offer more help for you .

    Best regards
    • Marked as answer by Yolanda Zhu Wednesday, December 17, 2014 10:10 AM
    Wednesday, December 10, 2014 9:19 AM

All replies

  • PLease post your question here : https://social.technet.microsoft.com/Forums/office/en-US/home?forum=excel

    (Excel Forums)


    Arnav Sharma | http://arnavsharma.net/ Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    Wednesday, December 10, 2014 12:33 AM
  • Hi Chland1214,

    Please try the following two methods to have a check .

    1. Disable add-in and open the files .

      In Excel, click on File<Options< Add-ins.

    Under Manage select COM Add-ins.

      Click on GO options beside Manage, uncheck all the add-ins and click Ok.

    2. Open excel file in safe mode. If it still crashed, copy the content of your excel file to a new workbook to check the issue. When it worked fine in safe mode, do a repair for Office in Control panel>Program and features>Office Version >Change>Repair.

    To open excel in safe mode:

    Click on Start< All Programs< Accessories< Run

    In Run window and type Excel /safe

    Note: There is a space between Excel and /.

    If the issue persists , I agree with Arnav Sharma. The technet excel forum will offer more help for you .

    Best regards
    • Marked as answer by Yolanda Zhu Wednesday, December 17, 2014 10:10 AM
    Wednesday, December 10, 2014 9:19 AM