Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Excel Crashes Way Too Often

Posted on 2006-06-28
8
Medium Priority
?
370 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

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

This article describes a serious pitfall that can happen when deleting shapes using VBA.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

719 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