Excel 2013 crashes when compiling after automatic repairs

insomniac53

Board Regular
Joined
Sep 3, 2013
Messages
104
This is an edited re-post as I received no replies first time around a few days ago. I could really use some ideas and guidance.

I'm using Excel 2013 under Office 365 on a PC. Excel automatically repaired a fairly complicated package I've been working on but I'm not sure what happened or why it needed a repair. At the moment I can load the program I've written but as soon as I try to Compile, Excel crashes (Excel has stopped working...)

The log for repairs says:
xml version="1.0" encoding="UTF-8" standalone="yes"?
recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"logFileName>error092360_01.xml<summary>Errors<summary><summary><summary><summary><summary> </summary></summary></summary></summary></summary></summary>
During some load attempts, I have received this message:
Removed Feature: Object from /xl/workbook.xml part (Workbook)
Removed Feature: OLE Control Extension from /xl/workbook.xml part (Workbook)
Lost ActiveX controls.
Can anyone tell me what they think might be going on and what I can try to get back on track again? Thanks!
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
It looks like you have had one, or more, activex controls removed from the file. It's probably worth trying to figure out which one(s) and then adding replacements, using the original names, so that the code shouldn't have any errors. Hopefully you also have a backup copy.
 
Upvote 0
Dear Rory,

Thank you for this. I'm not sure how to do replace the lost information but meanwhile much has happened. Because I posted on a couple of forums, my replies are similar. The good news is that the code is compiling again. Why? I wish I knew. First, I ran a program by another user to modify and make consistent all control references. No luck. I checked the Tools->References and varied the included modules, but nothing worked - the compiler kept crashing - every single time it ran. I also tried gradually removing the latest code and recompiling, but with the endless crashes, it was impossible to pinpoint the precise line where everything falls apart. I also asked some specialist companies but they charge exorbitant amounts for unspecified work.

Someone from another forum suggested an Appspro Code Cleaner which loads as a COM add-on into Excel. I'm wary of these third party programs, but I had nothing to lose so I tried it. No luck again. However, I contacted the author and he offered to look at the file. He ran it on a Windows 7 system using Excel 2010, and it compiled perfectly! He sent the compiled program back to me and, magically it seemed, it compiled on my system. He made no alteration to the code at all. He said that many of his clients have had similar issues with Windows 8 (or 8.1) running Excel 2013 and said that there seems to be some deep instability between VBA 7.1 and Windows 8, which is a worry. My guess, and it is just a guess, is that a critical flag is set by the code, even if it is clean, and this flag keeps telling Excel to shut down.

If it's possible for users with a similar problem to run their file through a different Windows/Excel configuration, it might be worth a try if they are pulling their hair out over endless compiler crashes.

Thank you for the reply. I almost gave up.
 
Upvote 0

Forum statistics

Threads
1,213,520
Messages
6,114,101
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top