Ask a new question

64 bit excel crashes

64 bit excel crashes on an irregular basis.

 

The application log error generated after a crash is as follows:-

   Faulting application name: EXCEL.EXE, version: 14.0.6126.5003, time stamp: 0x505b0843

 

   Faulting module name: VBE7.DLL, version: 7.0.16.27, time stamp: 0x4f863856

   Exception code: 0xc0000005

   Fault offset: 0x00000000000ca81b

   Faulting process id: 0x1730

   Faulting application start time: 0x01cddd7b58c52a9f

   Faulting application path: C:\Program Files\Microsoft Office\Office14\EXCEL.EXE

   Faulting module path: C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA7\VBE7.DLL

   Report Id: 9e1660a0-496e-11e2-8327-60d819b783b8

 

I have developed a technique to recover a crashed file.   This involves:-

  1. Disabling all macros
  2. Opening the file and making any minor change to the VBA via the VBE
  3. Saving the file
  4. Reopening the file with macros enabled.

 

I would like to prevent future crashes of this type.   Any help would be appreciated.

Hi Keith900834,
 
Does it crash on just this file?
 
 
Regards,
Jan Karel Pieterse
Excel MVP
https://jkp-ads.com
https://excelexperts.nl

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi Jan,

 

Thank you for your question.

 

I am a fan of your Name manager product and am eagerly awaiting the release of 64 bit Fast Excel.

 

Excel crashes on any one of 20 or so files that comprise a single financial model that I have built over the last 5 or six years.   Last year the model was migrated from 32 bit excel 2003 to 64 bit excel 2010.   Prior to conversion this issue did not exist.  The crash does not happen regularly or when opening any particular file and my feeling is that it may relate to a bug in VBA.   The files are in daily use.  On occasion there are weeks between crashes and I begin to hope that Microsoft has resolved the issue via an update but sometimes multiple crashes occur in quick succession.   THe crash is not machine specific and has happened on more than one computer.

 

I am running a number of addins :

  • Your name manager - you assisted me with an installation issue a year or two ago
  • Power Utility Pak v7.1
  • and also one that I have developed myself to assist in model construction.

As mentioned in my original question, making any change to the VBA project (even a single letter in a comment blocked line) appears to reset or re-compile the VBA project and allow the offending file to open.

 

Kind regards,

 

Keith

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi Keith900834,
 
Unfortunately, I regularly see problems with Excel files with a "rich history",
especially when these files come from Excel 2003 or before and now are used in
Excel 2007 and 2010.
 
Excel 2003 was a bit more forgiving about what I call "irregular content" in
files. Later Excel versions are more picky.
 
It is likely your Excel files have acquired debris that Excel 2010 does not
like. I would look out for:
 
- (Many) custom styles (cell style dropdown)
- (Many) on-sheet objects
- Errors in (hidden) range names
- Database queries not in a table object (somehow it looks like Excel 2010
misbehaves with these sometimes as 2007/2010 always insert a table for a
database query, whereas 2003 didn't)
- Lots of formatting
 
 
Regards,
Jan Karel Pieterse
Excel MVP
https://jkp-ads.com
https://excelexperts.nl

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi Jan,

 

Thank you for your response.

 

I will look out for the things you suggest.

 

Regards,

 

Keith

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi Jan

 

I am also facing similar issue where excel crashes because of VBE7.

 

Per your comments above, can you please recommend process/tools to cleanup the debris(if any) from the excel file.

 

Thanks.

Brijesh

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi BrijeshK,
 
My tool sometimes helps:
 
www.jkp-ads.com/productsremediation.asp
 
Code cleaner by www.appspro.com is a good tool if it comes to cleaning up VBA.
 
 
Regards,
Jan Karel Pieterse
Excel MVP
https://jkp-ads.com
https://excelexperts.nl

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

I have a similar problem often and it is related to VBA. Here's a work-around I use:

 

1) Always have Macros disabled with notification. If you don't then Excel will crash on opening the file because it will encounter the error directly.

 

2) With macros disabled the filw should open and ask you to enable macros. If you click on "Enable Content" Excel will crash. Instead go to the "developer" tab then click on "Visual Basic" on the ribbon. On the left "Project Navigator" window scroll down until you see "Modules". Right Click on "Modules" and select "Insert" -> "Module". This will insert a blank module. I think this resets the VB as "uncompiled" or something.

 

3) Save the workbook and re-open. You can then click on "Enable Macros" and Excel will not crash.

 

4) Before you save a file that tends to crash, insert a blank module. You can always delete them later.

 

I hope this helps someone.

 

 

 

 

2 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

A fix it looks like - Technet addresses this here: http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2012/09/07/excel-crashes-in-vbe7-dll-running-or-enabling-macro.aspx

3 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Helped me BIG TIME.  Thanks!

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Install this package, solves the problem:

https://support.microsoft.com/en-us/kb/3039734

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated May 27, 2024 Views 13,612 Applies to: