Unlocking a Shared File Locked for Editing

  • GT500Shlby
  • Guru
  • Guru
  • User avatar
  • Joined: Jul 28, 2004
  • Posts: 1205
  • Loc: Philadelphia, PA
  • Status: Offline

Post July 24th, 2006, 10:57 am

At work, I have a large SAN (Storage Area Network). On a shared drive thats run through a clustered NAS that is directly attached to the SAN, the entire department (~110 people, 200+ workstations including labs) has an excel file that we all use. Unfortunately, some 'person' either on their machine or a lab machine opened the file and now it is locked for editing.

I can't sniff trough 200+ computers so, anyway to force unlock it?

Any way to find the computer responsible. If I can find the IP address and I can lower the number of computers down to a specific lab (by subnets). I have full administrative access to the NAS (Windows 2003 Server Datacenter using DFS and Clustering), the SAN (not much help it will do), and to all the shares. Even logged on as myself and being the only person with full administrative rights on all the files it still wont let me use it. Excel still says its locked for editing.
"Now, I don't want to get off on a rant here, but..." - Dennis Miller
Image
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post July 24th, 2006, 10:57 am

  • lucassix
  • Mastermind
  • Mastermind
  • User avatar
  • Joined: Sep 13, 2004
  • Posts: 2344
  • Loc: Living in a VAN DOWN BY THE RIVER!
  • Status: Offline

Post July 24th, 2006, 11:00 am

Doesn't Excel usually tell you the username of the person who has it open?
  • optek
  • Novice
  • Novice
  • No Avatar
  • Joined: Jul 22, 2006
  • Posts: 28
  • Status: Offline

Post July 24th, 2006, 11:09 am

if the excel file is locked for editing, you'll probably need to find the person by his/her username/author and his/her password to unlock the excel file. you can probably look on its author.
  • GT500Shlby
  • Guru
  • Guru
  • User avatar
  • Joined: Jul 28, 2004
  • Posts: 1205
  • Loc: Philadelphia, PA
  • Status: Offline

Post July 24th, 2006, 11:10 am

Doesn't help - It just gave initials. It said 'AAA'.

This one has another 3 letters, but didn't match a person.

I eneded up backing up the file, bringing down the entire DFS link, deleting the file locally on the NAS, Bringing back up the DFS link, and then replacing the file.

Entire department is now getting nasty Email. :twisted:
"Now, I don't want to get off on a rant here, but..." - Dennis Miller
Image
  • lucassix
  • Mastermind
  • Mastermind
  • User avatar
  • Joined: Sep 13, 2004
  • Posts: 2344
  • Loc: Living in a VAN DOWN BY THE RIVER!
  • Status: Offline

Post July 24th, 2006, 1:20 pm

I found this on Ask-Leo.com

Quote:
On the server, right-click on My Computer, then select Manage, expand Shared Folders, and click on Open Files. There you'll see a list of files on the server that are currently opened by other computers on your network. That'll tell you the User who has the file open. You'll need to then click on Sessions to see what computer(s) that user is connecting from.


From there you could use taskkill to kill the program on the remote computer

Quote:
TASKKILL /S computername /U domain\username /IM EXCEL.EXE
  • GT500Shlby
  • Guru
  • Guru
  • User avatar
  • Joined: Jul 28, 2004
  • Posts: 1205
  • Loc: Philadelphia, PA
  • Status: Offline

Post July 24th, 2006, 3:17 pm

NICE! I got to try that tomorrow.

Thanks.
"Now, I don't want to get off on a rant here, but..." - Dennis Miller
Image
  • Alkatr0z
  • Mastermind
  • Mastermind
  • No Avatar
  • Joined: Feb 08, 2004
  • Posts: 1883
  • Loc: Adelaide, Australia
  • Status: Offline

Post July 25th, 2006, 3:19 am

Quote:
From there you could use taskkill to kill the program on the remote computer

The bastard operator from hell's favorite tool?
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Joined: May 28, 2003
  • Posts: 23404
  • Loc: Woodbridge VA
  • Status: Offline

Post July 25th, 2006, 6:22 am

Actually you don't even need taskkill or even access the offending computer. Just right click the Open File in My Computer as described in lucassix's quote above, and choose "close open file". Works like a charm.
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
  • bendeg
  • Born
  • Born
  • No Avatar
  • Joined: Jan 14, 2011
  • Posts: 1
  • Status: Offline

Post January 14th, 2011, 6:55 am

ATNO / TW s last reply works like a charm.

Thanks ATNO / TW.
  • akemp
  • Born
  • Born
  • No Avatar
  • Joined: Sep 14, 2011
  • Posts: 1
  • Status: Offline

Post September 14th, 2011, 9:50 am

When all else fails, restart Windows explorer on the host machine or just reboot it.
  • GainfulShrimp
  • Born
  • Born
  • No Avatar
  • Joined: May 03, 2012
  • Posts: 1
  • Status: Offline

Post May 3rd, 2012, 1:37 am

In case anyone else finds this thread via search and it doesn't quite help their specific case, here's another potential solution...

I had a similar situation: various .xls/.xlsx files on a (Win 2K3/IIS) web server which could not be deleted (but needed to be!). When attempting to delete them either on the box itself or over the network, I would get 'access denied' messages. If I attempted to open the files in Excel (over the network), Excel would report that the file was already in use by some user or other. Trying lucassix's tip of looking in Open Files in the management console, simply showed some files and folders that I had open, but no other users were shown and the locked files weren't listed.

I knew that the users reported by Excel couldn't really have the files open, so it was driving me mad. Rebooting wasn't an option (for this problem).

Eventually I found Microsoft's Handle utility. I'm not allowed to post a link to it here apparently, but just Google it - it's in the SysInternals section of Microsoft's Technet site.

If you run it without parameters and output to a text file, you'll get a nice list of every file handle with the details of the process that has it open.

From this, I found that the (MS) Indexing Service (cidaemon.exe) - used for search in our case - had the files locked. I temporarily stopped the Indexing Service in the Services console, deleted the files without a problem and then restarted the indexing service.

I hope this helps somebody else facing similar frustrations. :)
  • grinch2171
  • Moderator
  • Genius
  • User avatar
  • Joined: Feb 11, 2004
  • Posts: 6740
  • Loc: Martinsburg, WV
  • Status: Offline

Post May 3rd, 2012, 5:15 am

Here's the link to the software mentioned by GainfulShrimp

http://technet.microsoft.com/en-us/sysi ... s/bb896655
‎"Be polite, be professional, but have a plan to kill everybody you meet." Maj. Gen. James Mattis

Post Information

  • Total Posts in this topic: 12 posts
  • Users browsing this forum: No registered users and 163 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 2011 Unmelted, LLC. Ozzu® is a registered trademark of Unmelted, LLC.