Solved

Excel Crashes Way Too Often

Posted on 2006-06-28
8
364 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
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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Introduction Perhaps more familiar to developers who primarily use VBScript than to developers who tend to work only with Microsoft Office and Visual Basic for Applications (VBA), the Dictionary is a powerful and versatile class, and is useful …
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

839 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