Excel keeps randomly crashing

Topic

New Reply

This has been an on going issue for almost 3 years. I hate to think the numerous hours I have spent trying to find the issue plus I know MS has spent numerous hours/days only to leave my computer in worse shape when they are done causing me more hours to correct whet they messed up. I have Windows 7 and 8.1 both with Office 2013, 64 bit, solid state drives, 16 GIGS and icore 5 and 7 so I have the power needed. This is the most recent crash which happened a few minutes ago.

Any suggestions is appreciated. I’ve tried most of the things on MS forum. Now, I do use a lot of conditional formatting but it will crash on a sheet within a book when I try to do a simple cut and paste. Copy and paste is no issue. Opening a new sheet to do a cut and paste is also not an issue. It seems to happen in my books with a Macro more often. Then again, when I run the same application on Office 2010 or even Vista which has 2007 I have no issues

-
-

1000

2

100

0x80000000000000

28729

Application

Larry-PC

-
EXCEL.EXE

15.0.4779.1001

564c32dd

VBE7.DLL

7.1.10.49

55a6b6cd

c0000005

0000000000051423

1048

01d134dfcf4667e3

C:Program FilesMicrosoft OfficeOffice15EXCEL.EXE

C:PROGRA~1COMMON~1MICROS~1VBAVBA7.1VBE7.DLL

d4afa514-a0d5-11e5-b48f-bcee7b88cd6d

Reply | Quote

Replies

This just crashed in Office 2010, same file, different sheet

Log Name: Application
Source: Application Hang
Date: 12/12/2015 8:36:12 AM
Event ID: 1002
Task Category: (101)
Level: Error
Keywords: Classic
User: N/A
Computer: Larry-PC
Description:
The program EXCEL.EXE version 14.0.7164.5000 stopped interacting with Windows and was closed. To see if more information about the problem is available, check the problem history in the Action Center control panel.
Process ID: 10cc
Start Time: 01d134e511a69d01
Termination Time: 0
Application Path: C:Program FilesMicrosoft OfficeOffice14EXCEL.EXE
Report Id: a7e52527-a0dd-11e5-8bb1-bcee7b88cd6d

Event Xml:

1002
2
101
0x80000000000000

28858
Application
Larry-PC

EXCEL.EXE
14.0.7164.5000
10cc
01d134e511a69d01
0
C:Program FilesMicrosoft OfficeOffice14EXCEL.EXE
a7e52527-a0dd-11e5-8bb1-bcee7b88cd6d
55006E006B006E006F0077006E0000000000

Reply | Quote

This article specifically discusses VBE7.dll and Excel crashes…

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

Thanks, I will go check it out

Reply | Quote

This article specifically discusses VBE7.dll and Excel crashes…

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

I tried both applications and my Macro is getting hug up still which will happen before it crashes or I have to crash it because if not it will sit and spin for hours. The weird thing is it was working fine for about an hour and then decided to sit and spin.

I guess what I am saying is even trying these 2 methods I still have the same issue

Reply | Quote

After it sat and spun for 10 minutes, I hut escape , the screen goes to gray shade and nothing else happens. I go to “X” it out and get this error

–
–

1002
2
101
0x80000000000000

28864
Application
Larry-PC

–
EXCEL.EXE
14.0.7164.5000
16e4
01d134ebd68afc01
0
C:Program FilesMicrosoft OfficeOffice14EXCEL.EXE
17882722-a0e0-11e5-8bb1-bcee7b88cd6d
55006E006B006E006F0077006E0000000000

Reply | Quote

Can you please post all the macros you are using in this workbook?

Reply | Quote

not sure why that smiley is in there, its not in my Macro

Reply | Quote

Sometimes I will get a debug error but can not seem to find how to fix this or what exactly it is

42906-image

Reply | Quote

This is the only Macro in the book

Sub ResetBackToGame()
Dim d As Double:
d = Application.WorksheetFunction.CountIf([i2:i101], “?”)
Dim i As Integer:
‘make sure user entered positive number 1 to 50 into Q5
If IsEmpty(Range(“Q5”)) _
Or Range(“Q5”) 50 Then
‘do nothing if is empty or value not between 1 and 50, inclusive
Exit Sub
End If
i = 50 – [q5]
Application.ScreenUpdating = False
[I2:O101].Copy Cells(3 + i – d, 9) ‘copies I2:O101 to position (3+i-d) rows down.
Range(“i2”, Cells(2 + i, 15)) = “?” ‘puts ? in I2 over & down to cleared row in O.
[i102:o152].Clear: [q5].ClearContents
Application.ScreenUpdating = True ‘not required, auto-resets to True at End Sub or Exit Sub
End Sub

Reply | Quote

Just to confirm, did you reboot after making the registry changes?

Sorry jwoods,

what registry changes?

Reply | Quote

This is my latest crash and now t says something about it an not find my project library too

–
–

1000
2
100
0x80000000000000

15970
Application
Larry

–
EXCEL.EXE
14.0.4756.1000
4b9c0870
VBE7.DLL
7.0.15.90
4b7b2131
c0000005
00000000000be561
608
01d1353c1299e81e
C:Program FilesMicrosoft OfficeOffice14EXCEL.EXE
C:PROGRA~1COMMON~1MICROS~1VBAVBA7VBE7.DLL
59e372b3-a12f-11e5-be94-b888e31e9527

Reply | Quote

If you all knew how aggravating this is. I have been trying to work since 8 this morning non stop not even breaking for lunch and a quick bite for dinner and probably have 2 hours of work done because of this non sense

42908-cant-find-projet-library

Reply | Quote

Now here is the strange part. I have just put office 2013 on the same computer and it opened the file just fine. It will do this. If it crashes in 2010 I can open it in 2013. If it crashes in 2013 I can open it in 2010 and it will work fine until it decides to crash

Reply | Quote

That looks like a missing reference to VBA in Excel.

As you know, the VBE7.DLL issue has been around for a long time.

It would be interesting to see if it occurred on a machine that had both a clean install of Windows and Office, with nothing else.

What should I do to my registry?

Reply | Quote

Nothing.

You mentioned you had tried both options in the link from post #2.

One was a registry change mentioned in Method 2 in that link.

When you make registry changes, you should of course backup the registry first, make the change, and reboot.

Ah, I did not do the registry change in method 2. Instead I unchecked compile on demand.

Should I try the registry change!

I’ll go do a search for the dll and let you know. Thanks for helping

Reply | Quote

Do a search and see how many copies of VBE7.DLL you have on your system.

See if there is one that is more current than the version posted in the Event log.

VBE7.DLL

7.1.10.49

Is Office/Excel up to date on patches?

it looks like I have 4 all together but there 2 of each I think. What should I do? delete 2 of them or all of them?

42914-VBE7.DLL_

Reply | Quote

I installed Office 2013 to see if the file that was crashing in 2010 would open in 2013 and it did. I was able to close the same file and reopen it in 2010 with no issues. This is the norm for this too and its been driving me crazy to figure out why its like this

Reply | Quote

I had similar problems, and eventually found that the reason was that the process was using ~2GB of memory (as shown in Task Manager) even though the file was a bit under 1 MB. Randomness apparently resulted from details of preceding memory allocations. I was able to break the file into numerous smaller ones with inter-file links, and the problem was solved. This was with 32-bit Excel, while I think you are using 64-bit Excel, but maybe someone forgot to change some variable in Excel from DWORD to QWORD or equivalent. If all else fails, maybe this possibility is worth checking.

Reply | Quote

I have … Office 2013, 64 bit

I recommend you uninstall Office 64-bit and install the 32-bit version. 32-bit is recommended by MS and most other experts, unless you have a specific known need for 64-bit. 32-bit software works just fine on a x64 PC.

Lugh.
~
Alienware Aurora R6; Win10 Home x64 1803; Office 365 x32
i7-7700; GeForce GTX 1060; 16GB DDR4 2400; 1TB SSD, 256GB SSD, 4TB HD

Reply | Quote