excel 2003 crashing at shutdown

[Lynn McGuire]

My Excel 2003 is crashing about every other time that I
shut it down. Does anyone have a fix for this ?

Thanks,
Lynn

 

[Dave Peterson]

Just some guesses...

First, does it crash only when you're editing a specific workbook (or a specific
set of workbooks)?

If yes, then I'd check to see what those workbooks have in common -- maybe a
misbehaving macro????

If it crashes with all/any workbook, then I'd try rebuilding my toolbar.

Close excel
use windows search to look for *.xlb
and delete all that you find (or move them to a safe location if you're worried)

And remember to look through hidden folders, too. People can have trouble
finding them.

If you can't find your files using windows start button|Search, then you could
use an old DOS command to search and delete/move them

Windows Start button|Run
type:
CMD
(to get to the Command prompt)

C:
(to get to the C: drive--change this to the drive that excel is installed on)

cd\
(to get to the root directory)

dir *.xlb /s

The /s says to search subfolders, too.

(There could be multiple *.xlb files depending on your excel upgrade path.)

Then restart excel a few times to see if it crashes when you exit. If excel
behaves nicely, rebuild your toolbars the way you like.

If excel still crashes, then you can either rebuild your toolbar or put the
original toolbar (*.xlb) back to the correct folder.

============
If it turns out that there's a macro that's causing trouble, you may want to
read more about finding those problems.

Chip Pearson has some notes on how to diagnose errors:
http://www.cpearson.com/excel/StartupErrors.htm

And Jan Karel Pieterse has more notes:
http://www.jkp-ads.com/Articles/StartupProblems.asp

Essentially, you'll turn off all the addins/startup workbooks and then open
excel. And then turn on each addin (closing and reopening) one at a time to
find the culprit.

 

[Dave Peterson]

One more thing, I'd clean up the windows temp folder, too.

Close excel (all running programs you can see, actually)
hit Flying windows|r (to see the Run dialog)
Type:
%temp%

And delete as much as you can.

Then back to see if it helped excel's crashes.

 

[Lynn McGuire]

Just some guesses...

First, does it crash only when you're editing a specific workbook (or a specific set of workbooks)?

If yes, then I'd check to see what those workbooks have in common -- maybe a misbehaving macro????

If it crashes with all/any workbook, then I'd try rebuilding my toolbar.

Close excel
use windows search to look for *.xlb
and delete all that you find (or move them to a safe location if you're worried)

And remember to look through hidden folders, too. People can have trouble
finding them.

If you can't find your files using windows start button|Search, then you could
use an old DOS command to search and delete/move them

Windows Start button|Run
type:
CMD
(to get to the Command prompt)

C:
(to get to the C: drive--change this to the drive that excel is installed on)

cd\
(to get to the root directory)

dir *.xlb /s

The /s says to search subfolders, too.

(There could be multiple *.xlb files depending on your excel upgrade path.)

Then restart excel a few times to see if it crashes when you exit. If excel behaves nicely, rebuild your toolbars the way you like.

If excel still crashes, then you can either rebuild your toolbar or put the original toolbar (*.xlb) back to the correct folder.

============
If it turns out that there's a macro that's causing trouble, you may want to read more about finding those problems.

Chip Pearson has some notes on how to diagnose errors:
http://www.cpearson.com/excel/StartupErrors.htm

And Jan Karel Pieterse has more notes:
http://www.jkp-ads.com/Articles/StartupProblems.asp

Essentially, you'll turn off all the addins/startup workbooks and then open
excel. And then turn on each addin (closing and reopening) one at a time to
find the culprit.

I have no addins.

Excel 2003 crashes after editing any notebook.

I do have a File menu but my Edit, View through Help
menus no longer work.

I cleaned my temp directory.

I am looking for *.xlb files.

Lynn

 

[Lynn McGuire]

I have no addins.

Excel 2003 crashes after editing any notebook.

I do have a File menu but my Edit, View through Help
menus no longer work.

I cleaned my temp directory.

I am looking for *.xlb files.

Hey, deleting the excel11.xlb file worked !

Thanks,
Lynn