Solved

Excel 2010 process does not close when application is closed

Posted on 2010-11-16
8
1,830 Views
Last Modified: 2012-05-10
Dear Experts,

I have a user on Windows 7, Office 2010.  Whenever she closes Excel the process carries on running in task manager.  This causes a problem when she attempts to access a spreadsheet that she was using earlier, as it says that the file is in use / locked for editing.

She is not running and fancy scripts or VB programs, she is a sales administrator using a range of "standard" xls / xlsx files.

Can anyone suggest how to resolve this problem?  Are there any templates or anything that can become corrupted?

Any advice appreciated.

Cheers.
0
Comment
Question by:geoff_austin
  • 4
  • 3
8 Comments
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 34144518
Does she have any add-ins loaded?
0
 

Author Comment

by:geoff_austin
ID: 34145247
Add-ins screenshot
It looks like just the standard Microsoft ones to me...
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 34145310
Looks OK. Does this happen all the time with all workbooks, or just particular ones, or completely at random (seemingly)?
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:geoff_austin
ID: 34145918
It doesn't happen every time she closes Excel, but it seems to happen the majority of the time (e.g. 90%) apparently.  The user does not think any particular spreadsheets cause this behaviour.
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 34145944
It's not a bug I've ever heard of, but you might try reporting it to MS.
0
 
LVL 4

Expert Comment

by:yuppydu
ID: 34153691
Normally it happens with COM add-ins, not Excel add-ins. Detach all your COM add-ins and see if it fixes.
0
 

Accepted Solution

by:
geoff_austin earned 0 total points
ID: 34154096
Thanks for the response.

I've just checked her COM add-ins and there's nothing in there.  HOWEVER, I noticed on her PC in explorer she had the preview pane enabled (Windows 7) and an excel file was being displayed in the preview pane.  I suspect this may be the cause of her problems.

I have disabled the preview pane now so we'll see if the problem persists.  I will post an udate when I have one.
0
 

Author Closing Comment

by:geoff_austin
ID: 34228544
The preview pane in Windows 7 was keeping Excel open (when the user had a spreadsheet highlighted) which is why she'd been experiencing problems with files being read-only / locked for editing.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will show you how to use shortcut menus in the Access run-time environment.
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

766 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question