Office2k - excel error message

[kyrios]

I'll try these things on monday, thanks.

[kyrios]

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

[nihil]

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.

[dalek]

Try this:

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

[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

Another thought has come to me:

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?

[DjM]

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

Another thought has come to me:

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?

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:

[nihil]

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

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?

[dalek]

Maybe the OP needs to install this utility:

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

[oofki]

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

[dalek]

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

Can help in the shutdown process as well..

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