Excel Open and Close

[VBJ]

I have a problem, whereby sometimes after closing Excel and then looking on
task manager the excel process is still running. When opening excel again
all that appears is the menu icons and the grey surrounding the actual
spreadsheet. No actual spreadsheet appears. Needless to say it is also
locked up. If I close that spreadsheet, and also end the process for one
that is running in task manager, upon opening excel again it is fine.
I've tried doing detect and repair, but this doesn't help. It is also
intermittent as I guess only 50% of the time closing excel will still leave
the process running in task manager. I have Win XP pro and Excel 2002 with
all current service packs installed.

 

[Henry]

VBJ,

Do the workbooks that refuse to close have (autoquit) macros in them?
If so, I suspect that the autoquit process is not releasing the reference to
Excel.

HTH
Henry

 

[VBJ]

Nope, no macros running at all. It is intermittent, which is the frustrating
thing, so it can occur after closing any worksheet. Once, however the excel
process stays in task manager, however I do get continual problems opening
any worksheets.

Thanks for the response anyway