Working late here and one of my Excel applications decides to crash/corrupt for no reason at all.
Trying to open it will cause immediate shut down of Excel.
Does this happen to other users as well? Tell me about your experiences.
Working late here and one of my Excel applications decides to crash/corrupt for no reason at all.
Trying to open it will cause immediate shut down of Excel.
Does this happen to other users as well? Tell me about your experiences.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
.
Not to diminish the seriousness of your experiences but ...
Excel crashes and corrupts here ... ONLY ... on projects of great importance.
If I'm just messing around with coding ... Excel ignores my efforts.
Now ... the seriousness and level of the crash / corruption is directly proportional to the seriousness / level of importance of the project being worked on.
If the workbook is going to a fellow colleague the corruption is usually minor and requires just a few minutes of correction.
If the workbook is related to a major presentation before the Board of Directors, Mayor and Governor ... well then ... you can just forget ever getting to the presentation ... period.
Hope this helps.
@Jacc, mysugestion is
First of all try to use another account. In the case of Excel work correctly check any settings, Add-ins , personal workbooks. Some times many settings could be reset by edit registry HKCU/software/Microsoft/OfficeXX/excel ...... can be deleted.
in the case of Excel crash then try reinstall it and add-ins or uninstall at all clear and install again.
I missed. In this case check it on the another PC.one of my Excel applications
Last edited by BMV; 05-08-2020 at 01:29 AM.
Thanks for the reply guys!
Logit, you have a point there.
BMV, thanks for the tips!
It has been working fine since I created this thread. I get a major crash maybe once a month or something like that.
How frequent do other people experience crashes?
Frequency depends on what I am working on, and post-mortems usually reveal the following causes:
a. Active-X - known not to play well with others - real reason for crash usually Unknown
b. VBA Coding Errors such as:
(1) String Concatenation using Left(), Mid(), Right() specifying a string length is larger than the actual length of the string.
(2) Creating Data Validation from VBA array with total character length greater than 255 characters.
(3) Running out of heap/stack space caused by endless loop usually due to forgetting Appllication.EnableEvents = False
Lewis
Oh. I am a bit surprised here because those all seem like "valid" reasons for crashing.
I have moved away from Active X since a few years because of what they do.
I don't think my crashes are VBA related, I don't recall now.
In my mind it seems like Excel crashes for no reason at all. More like what Karlossus describes here: https://www.reddit.com/r/Windows10/c...on_windows_10/
Often when I try to do something a little bit more than just vanilla I run into trouble.
The Active x seems to be as unstable as it was decades ago. Why? I really like and would like to use what these controls offer but sadly no can do
And yes, fully updated, latest and greatest of everything, excellent IT department here.
.
Jaac:
A few months ago I purchased Office 2019 because I really wanted to upgrade from Excel 2007. After the "thrill" of new software wore off I quickly became
disenfranchised with the updated product.
Although I did not experience crashes as was your described events ... I did have numerous error messages when they should not have occurred. Basically
what Excel would do after a justified error message is to continue to display error messages no matter what changes I made to code. I finally learned to
completely reboot my computer to stop the error messages. Frustrating to say the least.
I also experienced Excel 2019 to not execute some very simple code until the code was run several times. Examples include a basic COPY FROM TO; moving
from one sheet to another via code and some other very simple macros.
I have decided to return to my original Office 2007 and things are much better now.
Guess what I am able to conclude from my experiences and yours .... the issues are most likely due to inadequacies in the overall software.
Perhaps give it a few years and maybe the new software version will smooth out.
Cheers !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks