Excel Won't Close

[Kirkpatti]

Hello,

I've just recently been upgraded from Excel 2000 to Excel 2003 at work.
Now, when I open Excel, I can do everything but close it.

Well, I can exit using, File -> Exit, but I cannot use the Red "X" button in
the upper right hand corner of the screen.

I ran Help -> Activate Product and it said it was already activated.
I ran Help -> Detect and Repair and it said all was installed properly.

Any ideas?

Thanks,

kp

 

[Jan Karel Pieterse]

Hi Kirkpatti,

ran Help -> Activate Product and it said it was already activated.
I ran Help -> Detect and Repair and it said all was installed properly.

Any ideas?

This is a default list of things-to-do when Excel exhibits (startup)
problems.

Try opening Excel without any addins or hidden workbooks:

Start, Run,
"C:\Program Files\Microsoft Office\Office\Excel.exe" /Automation

Quotes mandatory, Note you may have to change the path.

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

- 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

Also, you might try:

"C:\Program Files\Microsoft Office\Office\Excel.exe" /Regserver

Yet another possible problem is a corruption of your toolbar
customisation file. Locate all files with extension .xlb and rename the
extension(s) to something like .old
Now try and start XL again.

Also, NAV has shown to cause "Excel caused an invalid page
fault in module VBE6.DLL".
You might try disabling the Office plug in of NAV.

Other causes may be a full TEMP folder:

In Windows 95/98 and ME

Delete all files in C:\Windows\Temp

In Windows NT/2000/XP

Find and Select C:\Documents and Settings\<user>\local settings\temp
and delete all files in there.

They are often left behind by installing programs but Excel needs the
space.

Excel 2003 has some new features, which may disable certain files when
Excel thought them to be the cause of a crash.

If you have had a problem with Personal.xls, Excel may have labeled it as
suspect.
In Excel, select Help | About Microsoft Excel.
Click the button near the bottom labeled "Disabled Items..."
If Personal.xls is listed, select it and click Enable.

This is what MS has to say about startup problems:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q280504

And this about startup switches:

http://support.microsoft.com/default.aspx?scid=KB;en-us;q211481


Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[Kirkpatti]

Hey Jan,

AMAZING. It was your first suggestion that worked.

I'm totally impressed. How did you learn to figure out stuff like that?

Well, thank you for your expertise,
Kp

This one did the trick!

 

[Jan Karel Pieterse]

Hi Kirkpatti,

AMAZING. It was your first suggestion that worked.

But that does NOT fix your problem, it just prevents an addin from
loading which actually causes your trouble.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[Kirkpatti]

OMG, you are totally right. Now, I can close the program, but I cannot save
changes. Except that if I close using the red "x" button, it prompts me to
save and seems to keep my changes. But the File->Save/Save As... do not work.

I think I may have shot myself in the foot. How should I proceed from here?

Thanks,
Kp

 

[Elkar]

Are you using Novell GroupWise? If so, then I'll bet that is where the
problem is. Try this:

Close Excel
Open GroupWise
From the Tools Menu, select "Options..."
Double-click on the "Documents" icon
You may see an error ("no document libraries available"), click OK.
Uncheck the "Enable Integrations" box
Click OK
Click CLOSE

Now try Excel, does it work normally?

HTH,
Elkar

 

[Kirkpatti]

Elkar,

I am using Novell Groupwise and it seems to work, now. How did you know?
You peeps out there, are incredible.

thanks!

Kp