Office2k - excel error message

I have a user who always gets an error message only when closing Excel. Either a new template or an existing template. It only happens when you close excel.

The error message says, "Microsoft Excel for Windows has encountered a problem and needs to close. We are sorry for the inconvenience."

I have tried uninstalling and reinstalling. Then I have tried repair. The problem persists and there are no add-ins either.

Some help please, maybe there are some registry keys that need to be deleted.
Help! Thanks.

Quote:

---

Originally Posted by kyrios

I have a user who always gets an error message only when closing Excel. Either a new template or an existing template. It only happens when you close excel.

The error message says, "Microsoft Excel for Windows has encountered a problem and needs to close. We are sorry for the inconvenience."

I have tried uninstalling and reinstalling. Then I have tried repair. The problem persists and there are no add-ins either.

Some help please, maybe there are some registry keys that need to be deleted.
Help! Thanks.

---

Start\run\type "eventvwr.msc" without quotes

Select application and look for the little X's, click on one and read it's event info. As it's excel, you may be able to go directly to their website and get a description of the error type and fix if there is one, it may be you need to update Office 2000.;)

Funny.. I just got the exact error on Excel this morning from one of my users here... same version of Office.

Repair. Nope. Reinstalled. Nope. Finally ran as admin, and that cleared the issue. Eventvrw.msc showed nothing. Not a thing.

*EDIT: eventvwr.msc showed nothing excel or office related.

Quote:

---

Originally Posted by dalek

Start\run\type "eventvwr.msc" without quotes

Select application and look for the little X's, click on one and read it's event info. As it's excel, you may be able to go directly to their website and get a description of the error type and fix if there is one, it may be you need to update Office 2000.;)

---

Ok i'll try that.

Quote:

---

Originally Posted by MrCoffee

Funny.. I just got the exact error on Excel this morning from one of my users here... same version of Office.

Repair. Nope. Reinstalled. Nope. Finally ran as admin, and that cleared the issue. Eventvrw.msc showed nothing. Not a thing.

*EDIT: eventvwr.msc showed nothing excel or office related.

---

Hmm... So you just ran the program as an admin? I'm pretty sure this user is an Admin on the computer.

Have you any other versions of office on the machine?

Newer outlook??

Sorry...didnt catch which version of excel you are running Kyrios..........

And OS??

And if you are accessing the template or document from a mapped drive??

MLF

Quote:

---

Originally Posted by morganlefay

Have you any other versions of office on the machine?

Newer outlook??

Sorry...didnt catch which version of excel you are running Kyrios..........

And OS??

And if you are accessing the template or document from a mapped drive??

MLF

---

That is the only version of Office on the Machine which is office 2000.

And Outlook 2003 is being used.

OS is Windows XP Pro.

Documents are being accessed from the local hard drive. It doesn't really matter, error only appears when you close Excel. :(

Sounds like a VB issue...I have had this with multiple versions of office installed...and yes outlook is considered office.

I currently run Access 87
Work and Excel 2000
Outlook 2003

I have a hunch that Outlook was installed BEFORE Excel 2000.


You may be able to fix this by removing all MS Office programs...restarting...and then installing the MS office programs back in order.

Oldest first....

So basically remove Office and Outlook...restart the machine and then add Office 2000...the Outlook.

May work....off to find some references for you

Is the Excel part of an office suite??

If so which one...Small Business...Professional etc?? or just excel and no other office products??

MLF

edit> troubleshooting excel
http://support.microsoft.com/kb/280504

Yeah... that really could be almost anything. Click "view details" and it will probably at least tell you which module is causing it.

Just out of curiosity, can you create a new user account and see if you get the same problem?

I see what you are up to nihil. Always a good variable to take a look at..

I'll try these things on monday, thanks.

Nothing seems to work with this error messsage still....

OK, first can I confirm that you have:

1. Tried creating a new user account
2. Tried with an administrator account other than the user with the problem.

Some suggestions:

1. Get CCleaner and run it.
2. In your taskbar and start menu clear recently accessed records
3. Run chkdsk and then defrag........... how much % free space is there on the drive?
4. Boot into safe mode and try opening and closing Excel from there.
5. Google and get VB6 SP6 and VB5. Just reinstall them over the top of the existing files.
6. Burn the documents to a CD/DVD, or ship it down the network, and try them on another machine with a known working copy of Excel.

Some more questions:

1. Does this user have a specific Excel spreadsheet?
2. Does the problem happen if they just open Excel DO NOT OPEN A SPREADSHEET, just Excel, then close it?
3. What is there in the XP system logs? Applications is favourite, but do look at the others.
4. What message do you get if you shut down Windows with Excel still active? Like let 'doze close it in it's own way ;)

Let us know how you get on.

Try this:

Quote:

---

When I try to open XL, it freezes and all I can do is reboot
* Excel crashes on me regularly, what can I do
* EXCEL caused an invalid page fault...
* Illegal Operation Error when starting Excel

To-Do List:
Try opening Excel without any addins or hidden workbooks:

1. On the Windows taskbar, click the Start button
2. Choose Run
3. Type "C:\Program Files\Microsoft Office\Office\Excel.Exe" /Automation (include the quotes) -- adapt to fit your path.

If your error disappears, there is either an add-in or a (hidden) workbook that is loaded upon XL's start, which is causing problems.

• Try locating the XLSTART directory, move everything from there.
• In XL: Tools, Addins, note the ones checked and uncheck them one at the time, each time restarting XL
• In XL, Tools, options, general. Check if a path is entered after "Alternate startup file location". Clear it.

Another option is to open XL in Safe mode:
"C:\Program Files\Microsoft Office\Office\Excel.exe" /Safe

---

http://www.contextures.com/xlfaqApp.html

Hi Dalek,

Problem here is that this is a problem on shutdown? Like you say "shutdown", and it says "I am having a problem, I'm going to shutdown".

If I didn't know better I would say it was a mistimed Microsoft April Fools prank :D

Another thought has come to me::idea:

1. Go into your AV and remove the "scan on file close" or "scan on write" options.

2. If you are using encryption, turn it off. That usually happens on shutdown.

Something is interfering with the shutdown ............. question is what?

:confused:

Quote:

---

Originally Posted by nihil

Hi Dalek,

Problem here is that this is a problem on shutdown? Like you say "shutdown", and it says "I am having a problem, I'm going to shutdown".

If I didn't know better I would say it was a mistimed Microsoft April Fools prank :D

Another thought has come to me::idea:

1. Go into your AV and remove the "scan on file close" or "scan on write" options.

2. If you are using encryption, turn it off. That usually happens on shutdown.

Something is interfering with the shutdown ............. question is what?

:confused:

---

Nihily is likely on to something here. I used to have problems with Norton when a laptop I had shutdown. With Norton there was an option of "Scan on shutdown" or something like that. When I disabled that, the problem went away.

Cheers:

DjM,

Go and wash down your keyboard with soap and water!............. I was going to mention N****n but thought that people might think me prejudiced :D

I think that Mc****e may suffer a bit the same these days?

Scan on shutdown/write is OK, but the problem is that these days people tend to be running so much more and the machines are so damn fast? Just opening and closing files isn't a problem, but actual system shutdown presents a sort of "bottleneck".

Stuff runs into other stuff? :(

If we get the answers to all my questions and he does what has been suggested I am confident that we can at least narrow down the culprit or the problem will have been fixed?

Maybe the OP needs to install this utility:

Quote:

---

Overview

The User Profile Hive Cleanup service helps to ensure user sessions are completely terminated when a user logs off. System processes and applications occasionally maintain connections to registry keys in the user profile after a user logs off. In those cases the user session is prevented from completely ending. This can result in problems when using Roaming User Profiles in a server environment or when using locked profiles as implemented through the Shared Computer Toolkit for Windows XP.

On Windows 2000 you can benefit from this service if the application event log shows event id 1000 where the message text indicates that the profile is not unloading and that the error is "Access is denied". On Windows XP and Windows Server 2003 either event ids 1517 and 1524 indicate the same profile unload problem.

To accomplish this the service monitors for logged off users that still have registry hives loaded. When that happens the service determines which application have handles opened to the hives and releases them. It logs the application name and what registry keys were left open. After this the system finishes unloading the profile.

---

MS Download UPHClean

Thats only for when you log off of windows dalek...

Quote:

---

Originally Posted by oofki

Thats only for when you log off of windows dalek...

---

Can help in the shutdown process as well..

Quote:

---

This UPHClean service checks for leaked connections to the registry and releases them accordingly. So your computer will shut down faster.

---

http://labnol.blogspot.com/2006/07/m...dows-shut.html

You can also use it to troubleshoot shutdown/Logoff errors.
http://download.microsoft.com/downlo...5ac/readme.txt

Users problem is not related to shutdown/logoff...only to closing the applicaton.

Quote:

---

Originally Posted by kyrios

I have a user who always gets an error message only when closing Excel. Either a new template or an existing template. It only happens when you close excel.

---

As Morganlefay said, uninstall all office products (including Outlook 2003) and reinstall them begining with oldest version first. Per Microsoft KB Article 828956:

If you want to install and use more than one version of Office on the same computer, you must install the earliest version first. For example, if you want to use both Office 97 and Microsoft Office XP on the same computer, install Office 97 first. You must follow this step because of the way that registry keys, shared programs, file extensions, and other settings are managed for each version of Office, and for the programs that are included with each version of Office.

The following table shows the order that you must use install each version of Office.

Office 97 -- First
Office 2000 -- Second
Office XP -- Third
Office 2003 -- Fourth

Important: If you subsequently remove one of the installed versions of Office, you may have to reinstall the remaining versions of Office in this order for each version to work correctly.

The remainder of this article assumes that you installed the versions of Office in this order.

See KB Article 828956 for more info.

http://support.microsoft.com/kb/828956/

Hope it helps,

CC