Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel Crashes Way Too Often

Posted on 2006-06-28
8
Medium Priority
?
371 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
New style of hardware planning for Microsoft Exchange server.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

886 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