Solved

Excel file locked by System process (PID 4)

Posted on 2010-08-26
3
2,107 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
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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

772 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