Solved

Excel Crashes Way Too Often

Posted on 2006-06-28
8
367 Views
Last Modified: 2012-08-13
On just about every file exit, I recieve the notification to send an error report to MS. My files frequently do not function correctly, forcing me to either shut the program down and relaunch or reboot and then relaunch.
The files I am working on are small Excel worksheets, with self created VBA macros when the problem arises. Which is almost all the time now.
I reinstalled Office and am still experiencing the same results. My machine is quite capable to handle the memory and processing demands, 3ghz w/ 4gigs of ram.
Win XP, Office 2003.

thanks
0
Comment
Question by:DougStroud
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 18

Expert Comment

by:p912s
ID: 17006343
Have you loaded all of the patches for Office?

Office Update Site
  http://office.microsoft.com/en-us/officeupdate/default.aspx


Here's a few links that cover installing and repairing Office.

How to install or repair and reinstall Office 2003 programs and features
http://support.microsoft.com/kb/821593/en-us

How to understand the repair feature in Office 2003 and in Office XP
http://support.microsoft.com/kb/822238/en-us

Description of the differences between repair and reinstall in Office XP and 2003
http://support.microsoft.com/kb/298027/en-us
0
 
LVL 27

Expert Comment

by:David-Howard
ID: 17006441
Does this error occur with only Excel or do you experience it with other portions of the Office suite?
0
 

Author Comment

by:DougStroud
ID: 17007524
I almost exclusively in Excel. Outlook is used on a limited basis and does not incur the same amount of crashing.
0
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 

Author Comment

by:DougStroud
ID: 17007528
Yes.
0
 

Author Comment

by:DougStroud
ID: 17009483
Ok,
I have found the problem, now what is the resolution?
I think I have narrowed down the culprit that crashes, or a better description, creates the "encountered a problem and needs to close" message box and causes all sorts of instability issues. There is something inside my VBE module, I believe.

Whether I open an existing workbook that have macros attached to it or a new workbook that have no macros and I simply open the VBE, and then do nothing else and close the file and program, I receive this error. If I simply open the same two files and close the files w/out accessing the VBE, I do not receive this error upon exiting. I uninstalled Excel and reinstalled the program completely yesterday only to experience the problem all over again. This lead me to tracking this issue step by step.

I just tested my theory on another computer w/ the file containing the same macros and the same result was experienced. So it must be something in a module.

If I am correct and this is the problem, how do I locate or correct the offending module, or could it be the entire VBE application and this needs some sort of repair?
0
 

Author Comment

by:DougStroud
ID: 17016880
Do I get the 250 points if I solve the problem myself? Can I raise the value, now that I know how difficult the resolution was? :-)

I may have located the problem you were having w/ VBE crashing Excel.
See post and link:

[quote]Roy,
I am not sure which one, Adobe or Efax was causing the overall problem. I suspect both. Reason: When I uninstalled Adobe, which was first to happen, I could then deselect Default to Full Module View, and then exit the program right away w/ no program crashing. I only then started removing all associations w/ other PDF programs and Efax happens to dock an icon on the menu toolbar.
Efax has been a good program and now that I know that there could be some conflict I will reinstall it in a few days after more testing that this indeed was the issue. If then a problem occurs, I will contact the company for more info. The following link may prove helpful, and I want to offer credit to the original author and gumshoe detective that discovered the problem: http://www.eggheadcafe.com/forumarch...st24120052.asp[/quote]



[quote]9/6/2005 9:45:19 PM Re: VBE causes excel and word to crash when closed
Thanks for the useful tips.

I think I found it. After removing Adobe PDFWriter and its office

macro's the problem disappeared. Probably one of these automatic updates

by Adobe has introduced the problem a week ago. Now Excel starts up in a

quarter of the time and shuts down in a tenth of what it used to do.

PDFCreator is nicer anyway without all the macro klimbim. So I am

happily waiting for the next mysterious problem.

Janwillem van Dijk wrote:[/quote]  

Full Thread:
http://www.ozgrid.com/forum/showthread.php?p=271344&posted=1#post271344

Excerpt to resolution post:

[quote]Jack- as to your posts, I am still unclear on two things. 1. Holding down the shift key and opening a file did not supress macros from loading, what I mean to write is, the msgbox to enable or disable macros still pops up. Is this what you mean or is there something I am not doing correctly following your instructions?
Second- uninstalling and reinstalling Office the correct way- In a follow-up post I inquired regarding how to uninstall correctly. Are you saying to uninstall w/ the disk and not through the control panel? Can you provide more info here?
As for the link regarding the removing all traces of Office, thanks. But after reading the description, it seems to me this only applies to situations where the installation was an upgrade, not a new installation, which in my case was a new install.[/quote]

Thought these follow up comments will help other viewers sometime or another.

Cheers,

Doug Stroud
0
 
LVL 1

Accepted Solution

by:
DarthMod earned 0 total points
ID: 17232142
PAQed with points refunded (250)

DarthMod
Community Support Moderator
0

Featured Post

Increase your protection from Zero Day threats!

Running two Antivirus' is never a good idea.
Taking advantage of Multiple Security layers on the other hand can often save your hide.
See which top notch security software brands have been proven to happily coexist together.
Reduce your chances of becoming a statistic.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question