Results 1 to 13 of 13
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Chantilly, VA USA
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel 2010 Crashes

    I've recently upgraded to Win7 and Office 2010 on a new, robust desktop PC. I have a moderately complex workbook that was build up in Excel 2007. File is about 1GB, with some embedded charts etc. There are a number of LOOKUPs in the primary worksheet.

    It was fairly stable in Excel 2007.

    Ever since the upgrade I've had repeated issues with Excel freezing and crashing. The problem seems most acute when I try to Insert a Row in the middle of a worksheet, which I usually do using COPY > INSERT COPIED CELLS.

    I'm experiencing the same problem with some other workbooks, but to a much lesser degree. But this particular function seems to take a long time on all workbooks.

    Is there a general stability problem here, and any suggestion on how to pinpoint the cause of the problem?

    thanks,

    Don

  2. #2
    New Lounger
    Join Date
    Dec 2001
    Location
    Romsey, England
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Have you checked Windows itself? Run chkdsk from a cmd box and see if it comes up with any errors. If it does, run chkdsk c: /f, reply Y when it asks to do it from a reboot, and then restart. If no errors show, then we'll think again.

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    5,895
    Thanks
    0
    Thanked 85 Times in 81 Posts
    I would try a different default printer. If you set the default as say the MS XPS document writer, does that make any difference?
    Regards,
    Rory
    Microsoft MVP - Excel.

  4. #4
    Star Lounger
    Join Date
    Jun 2002
    Posts
    98
    Thanks
    1
    Thanked 0 Times in 0 Posts
    I also have the same problem starting last night. Another user within the company reported macro crashing Excel. I shared his screen and watched it happen. Then last night it began to happen to me too. Macros had been running fine previously for all. Macros run fine when stepping through. In fact, the crash occurs at different stages in the code if I run to a breakpoint and then F5 to continue unimpeded...Excel completely crashes. We do have corporate IT sending Windows 7 updates without warning and we did have a boot-required update this week. So I'm suspecting something in our Windows environment (Sophos, McAfee Endpoint Encryption) is the cause. Workarounds like scattered "DoEvents" in code, or tinkering with code itself may work, but this feels like a bug that needs to be reported to Microsoft. Our Help Desk is not able to handle this. How do we report something like this to Microsoft without a $250 charge for the privilege?
    __________________________________________________ ____
    <img src=/S/nun.gif border=0 alt=nun width=20 height=20> Sister Dory
    Our Lady of Perpetual Help, Holstein Falls, Wisconsin, USA

  5. #5
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    10,287
    Thanks
    130
    Thanked 1,154 Times in 1,063 Posts
    Quote Originally Posted by DoryO View Post
    I also have the same problem starting last night. Another user within the company reported macro crashing Excel. I shared his screen and watched it happen. Then last night it began to happen to me too. Macros had been running fine previously for all. Macros run fine when stepping through. In fact, the crash occurs at different stages in the code if I run to a breakpoint and then F5 to continue unimpeded...Excel completely crashes. We do have corporate IT sending Windows 7 updates without warning and we did have a boot-required update this week. So I'm suspecting something in our Windows environment (Sophos, McAfee Endpoint Encryption) is the cause. Workarounds like scattered "DoEvents" in code, or tinkering with code itself may work, but this feels like a bug that needs to be reported to Microsoft. Our Help Desk is not able to handle this. How do we report something like this to Microsoft without a $250 charge for the privilege?
    If you add the folder where the Excel files with macros are kept to the list of trusted locations, the crashing will stop. If you need to know how to do that, check this: http://faculty.fuqua.duke.edu/~peckl...20security.pdf

  6. The Following User Says Thank You to ruirib For This Useful Post:

    DoryO (2011-08-18)

  7. #6
    Star Lounger
    Join Date
    Jun 2002
    Posts
    98
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Setting the "Trusted Locations" for my Add-In folder is a great idea. I did that. And then it actually was able to run successfully once.
    But it is now back to crashing. It crashes at different points...not always the same amount of progress through macro.
    I have milestones displayed in the status message so I can tell how far it gets. I put in a MsgBox prompt just before the area that seemed to be the crashpoint, but it sometimes fails to get that far.

    I'm scanning for viruses.
    __________________________________________________ ____
    <img src=/S/nun.gif border=0 alt=nun width=20 height=20> Sister Dory
    Our Lady of Perpetual Help, Holstein Falls, Wisconsin, USA

  8. #7
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    10,287
    Thanks
    130
    Thanked 1,154 Times in 1,063 Posts
    I suppose you don't have the option to restore the system to a point where it was working? Or have a list of the change to check if any of them is known to cause issues?

  9. #8
    Star Lounger
    Join Date
    Jun 2002
    Posts
    98
    Thanks
    1
    Thanked 0 Times in 0 Posts
    This is is my Windows update history for the week:

    Security Update for Windows 7 (KB2536276)
    Installation date: ‎8/‎15/‎2011 10:00 AM
    Installation status: Successful
    Update type: Important
    A security issue has been identified that could allow an unauthenticated remote attacker to compromise your system and gain control over it. You can help protect your system by installing this update from Microsoft. After you install this update, you may have to restart your system.
    More information: http://go.microsoft.com/fwlink/?LinkId=215841


    Security Update for Microsoft Chart Controls for Microsoft .NET Framework 3.5 Service Pack 1 (KB2500170)
    Installation date: ‎8/‎15/‎2011 10:00 AM
    Installation status: Successful
    Update type: Important
    A security issue has been identified that could allow an attacker to compromise your Windows-based system that is running the Microsoft Chart Controls for Microsoft .NET Framework 3.5 Service Pack 1 and gain access to information. You can help protect your computer by installing this update from Microsoft. After you install this item, you may have to restart your computer.
    More information: http://go.microsoft.com/fwlink/?LinkId=221536
    Another user in the company first reported this error on his laptop yesterday when I still was functioning just fine. So I know its not just my machine.
    Other users are not crashing with the same Add-In macros. Which is why I'm suspicious of op system or Office or anti-virus software updates forced by IT to my laptop.
    __________________________________________________ ____
    <img src=/S/nun.gif border=0 alt=nun width=20 height=20> Sister Dory
    Our Lady of Perpetual Help, Holstein Falls, Wisconsin, USA

  10. #9
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    10,287
    Thanks
    130
    Thanked 1,154 Times in 1,063 Posts
    I didn't see any reports of either update causing Excel crashes. Can you disable the AV for a while and check if it has any impact?

  11. #10
    Star Lounger
    Join Date
    Jun 2002
    Posts
    98
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Corporate IT installed AV...Sophos Protection not possible to disable.
    I have just rolled out this Excel-based Add-in app to a new group of users and only one user so far is reporting this behavior.
    I am very concerned that inexplicable crashing will become rampant and I can't do any further development until its resolved.
    Is it possible to report behavior like this to Microsoft Office tech support?
    Last edited by DoryO; 2011-08-18 at 15:21.
    __________________________________________________ ____
    <img src=/S/nun.gif border=0 alt=nun width=20 height=20> Sister Dory
    Our Lady of Perpetual Help, Holstein Falls, Wisconsin, USA

  12. #11
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    10,287
    Thanks
    130
    Thanked 1,154 Times in 1,063 Posts
    I think these are the support options for Office: http://support.microsoft.com/gp/gp_off_main#tab4

    Doesn't look like you can get any official help other than through a paid option, or unless you have a support contract of some kind.

  13. #12
    Star Lounger
    Join Date
    Jun 2002
    Posts
    98
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Recreated all my files (addins,templates,Access databases) from "parts" in Office 2010 to eliminate any conversion issues from prior Office versions.
    That got me to the point where my macro runs without crashing Excel during the macro.

    But now I have the same problem reported over at this thread:
    http://www.ozgrid.com/forum/showthread.php?t=156653

    Macro runs first time OK. Second time the custom form comboboxes do not contain the array of choices. Subsequently, closing the workbook causes Excel to crash.

    I'm going to try uninstalling the last Windows updates from earlier this week. It must be an environmental problem with my laptop. Others are functioning just fine. One other user is having similar problems as I am.
    __________________________________________________ ____
    <img src=/S/nun.gif border=0 alt=nun width=20 height=20> Sister Dory
    Our Lady of Perpetual Help, Holstein Falls, Wisconsin, USA

  14. #13
    Star Lounger
    Join Date
    Jun 2002
    Posts
    98
    Thanks
    1
    Thanked 0 Times in 0 Posts

    My culprit: an HP Printer

    HP Printer as default was causing my Excel errors and crashing.
    I had a few lines that set up margins, headers.
    By turning off communication with the printer during these commands it allowed my macro to run without losing its mind.

    Code:
        Application.PrintCommunication = False
        With ActiveSheet.PageSetup
            .PrintTitleRows = "$1:$8"
            .PrintTitleColumns = ""
            .LeftFooter = "&8Printed: &D"
            .RightFooter = "&8Page &P of &N"
        End With
        Application.PrintCommunication = True
    
    Maybe this will also solve your crash problem?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •