Solved

locked excel file on network shared data drive

Posted on 2010-08-24
3
720 Views
Last Modified: 2012-05-10
i have a user excel file that says locked for editing by administrator- yet I am the administrator and I cannot get it to unlock- i have tried removing ownership- resetting permissions- nothing works
0
Comment
Question by:funkyone60
  • 2
3 Comments
 
LVL 10

Accepted Solution

by:
jorlando66 earned 500 total points
ID: 33511895
From the server right on My Computer and select Manage - expand Shared Folders - Open Files.  click on the file and select disconnect.
0
 
LVL 2

Expert Comment

by:Tordan
ID: 33511926
Try;
1. Copy file to you local desktop if it is on a network share, maybe you don't have rights to edit file where it is?
2. Open copied document, and select all, copy, and paste in new document?
3. if it really was locked, and you don't know the password, get one excel password recovery tools from someplace safe like www.download.com
0
 
LVL 10

Expert Comment

by:jorlando66
ID: 33511985
Tordan: He can not open the file because it is locked for editing.  He says nothing aout not having permissions to the folder as he is the administrator.
0

Featured Post

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!

Join & Write a Comment

I wanted to share this with fellow Experts, who might not know. How often have you wanted to learn something, only to be set back by either restrictions imposed on "trial" or "evaluation" software?  How often have you had to rebuild a home networ…
As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

747 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

12 Experts available now in Live!

Get 1:1 Help Now