Solved

Excel 2010 process does not close when application is closed

Posted on 2010-11-16
8
1,804 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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

707 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

15 Experts available now in Live!

Get 1:1 Help Now