Solved

Excel 2010 process does not close when application is closed

Posted on 2010-11-16
8
1,859 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

695 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