Solved

Excel Crashes Way Too Often

Posted on 2006-06-28
8
360 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
Comment Utility
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
Comment Utility
Does this error occur with only Excel or do you experience it with other portions of the Office suite?
0
 

Author Comment

by:DougStroud
Comment Utility
I almost exclusively in Excel. Outlook is used on a limited basis and does not incur the same amount of crashing.
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 

Author Comment

by:DougStroud
Comment Utility
Yes.
0
 

Author Comment

by:DougStroud
Comment Utility
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
Comment Utility
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
Comment Utility
PAQed with points refunded (250)

DarthMod
Community Support Moderator
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

728 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now