Solved

Excel 2010 process does not close when application is closed

Posted on 2010-11-16
8
1,814 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
 

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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Office.Com /myAccount 9 39
Excel partial font macro 14 26
command prompt wont close after executing batch file 11 34
Export Query data to excel file 14 28
This article will show you how to use shortcut menus in the Access run-time environment.
My experience with Windows 10 over a one year period and suggestions for smooth operation
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

919 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now