Solved

Excel file locked by System process (PID 4)

Posted on 2010-08-26
3
2,179 Views
Last Modified: 2012-05-10
Over the last couple of days some of our users are reporting file locks in Excel ('This file is in use by xxx') even though no obvious locks are present on the servers.

These locks seem to be the last user of the file (including the poor soul suffering from the cannot open message) and move with the file if renamed in Explorer.  The lock does not move if the file is duplicated using copy/paste though it can then occur on the second time of opening the file.

The file servers are Windows 2003 and Windows 2008R2 and the users could be accessing the files via Citrix (2000 or 2008R2 as the base), T/S to 2008R2 or XP directly from the laptop/desktop

Office is 2000 or 2007 and the files are either XLS or XLSX - none of these are shared workbooks - at least one of these files has never been accessed by Office 2000.

Looking at the files with Unlocker the only other thing that has a lock on these files is a System process called System running under System witha  PID of 4 and ending the lock from this has let the users back into the files fine.

I think the lock name reporting the last user in Excel is valid as we can track the lock between users if we open/close the file under controlled conditions but it seems the 'System' process has the actual lock.

Note not all files are doing this - not even in the same folders

To date no one else has reported Word or Powerpoint files suffering.
0
Comment
Question by:acstit
[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
3 Comments
 
LVL 12

Accepted Solution

by:
Daniel Borger earned 500 total points
ID: 33531545
Have you tried disabling oplocks? http://support.microsoft.com/kb/812937
Also I have seen same situation with Mcafee virus software.
https://kc.mcafee.com/corporate/index?page=content&id=KB61144
0
 
LVL 1

Author Comment

by:acstit
ID: 33539991
I have been caught before with oplocks a few years ago - totally forgot about that so I'll give that a go over the weekend if possible (unsure of downtime at this moment).

We use Trend inhouse due to the problems Mcafee caused me :-)


0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

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…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

710 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