Excel 2010 Crashes

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

I would try a different default printer. If you set the default as say the MS XPS document writer, does that make any difference?

Reply | Quote

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?

Reply | Quote

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/~pecklund/ExcelReview/Excel%202007%20and%20macro%20security.pdf

Reply | Quote

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.

Reply | Quote

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?

Reply | Quote

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=221536Another 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.

Reply | Quote

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?

Reply | Quote

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?

Reply | Quote

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.

Reply | Quote

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/?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.

Reply | Quote

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:

[B]    Application.PrintCommunication = False
[/B]    With ActiveSheet.PageSetup
        .PrintTitleRows = “$1:$8”
        .PrintTitleColumns = “”
        .LeftFooter = “&8Printed: &D”
        .RightFooter = “&8Page &P of &N”
    End With
[B]    Application.PrintCommunication = True
[/B]

Maybe this will also solve your crash problem?

Reply | Quote