File Sharing, file is locked cannot save
|
|
OP
Joined: Dec 2009
|
An intern was working on a excel file the other day, she saved, closed, and quit, and left the building, yet Apple says the file lock is locked by her and of course, I have to do a save as, another head wringer. thanks!
|
|
Re: File Sharing, file is locked cannot save
|
Joined: Aug 2009
Likes: 1
|
Joined: Aug 2009
Likes: 1 |
Are you sure she quit before she disconnected from the network? This will sometimes happen if you open a file across the network, save, disconnect from the network, and then quit. Since the network is disconnected, when you quit the application, it can't update the file lock on the network.
Usually, restarting the network server will fix this.
|
|
Re: File Sharing, file is locked cannot save
|
|
OP
Joined: Dec 2009
|
Tacit, thanks!, no I'm not sure. I'll make a note cool.
What do you mean by restarting the network server? It's must my imac to her laptop. I think I rebooted the imac and it still was locked.
|
|
Re: File Sharing, file is locked cannot save
|
Joined: Aug 2009
Likes: 16
Moderator
|
Moderator
Joined: Aug 2009
Likes: 16 |
The server is the computer the file is located on. It is "serving" as a file storage device.
If we knew what it was we were doing, it wouldn't be called research, would it?
— Albert Einstein
|
|
Re: File Sharing, file is locked cannot save
|
|
OP
Joined: Dec 2009
|
Joe, thanks! So what should unlock this? A reboot of the computer? something else?
|
|
Re: File Sharing, file is locked cannot save
|
Joined: Aug 2009
Likes: 15
|
Joined: Aug 2009
Likes: 15 |
Usually, restarting the network server will fix this. (Emphasis added) Just to cover all bases, try shutting down and restarting your iMac. Edit: You could have shut down and restarted in less time than it took to post the question.
Last edited by artie505; 09/19/11 10:07 AM.
The new Great Equalizer is the SEND button.
In Memory of Harv: Those who can make you believe absurdities can make you commit atrocities. ~Voltaire
|
|
Re: File Sharing, file is locked cannot save
|
Joined: Aug 2009
Likes: 16
Moderator
|
Moderator
Joined: Aug 2009
Likes: 16 |
Simply logging out of a user account and then logging back in will sometimes clear the problem and is the quickest fix. However, a reboot does the same thing and more although it takes more time.
If we knew what it was we were doing, it wouldn't be called research, would it?
— Albert Einstein
|
|
Re: File Sharing, file is locked cannot save
|
|
OP
Joined: Dec 2009
|
JOe, did log out, reboot and the shutdown, and the file is still locked. thanks.
|
|
Re: File Sharing, file is locked cannot save
|
|
Joined: Aug 2009
|
copy the file to a flash drive and try to open it on another computer. If it still refuses to open, the file has a lock bit set inside the document, by the application that was editing it (excel) and has nothing to do with the fileserver or filesharing.
I work for the Department of Redundancy Department
|
|
Re: File Sharing, file is locked cannot save
|
|
OP
Joined: Dec 2009
|
V, my guess is you 2nd idea is correct. Then what can I do? It's my file, my computer. I don't get it. I did command i, all read write.
|
|
Re: File Sharing, file is locked cannot save
|
|
OP
Joined: Dec 2009
|
PS, and doing a save as to a new name does not work!
|
|
Re: File Sharing, file is locked cannot save
|
|
OP
Joined: Dec 2009
|
NEW NEWS In fact it does open on on another computer. In fact in opens ok, if I copy it to the desktop!
But if I delete the file from the folder I usually keep it and and drag the one on the desktop that is opening ok back to the normal folder I keep my list in, then it's locked again (read only).
This is still a problem because this is the folder I like to keep these list. The folder is read/write as are the parent folders. So I'm still puzzled. The lock message still has the fill name of the intern in the lock message.
|
|
Re: File Sharing, file is locked cannot save
|
Joined: Aug 2009
Likes: 15
|
Joined: Aug 2009
Likes: 15 |
Try booting from your install disk and navigating to "Utilities," where, if I remember correctly, you'll find an option to repair your home folder permissions, again, if I remember correctly, included in the change-password drop-down.
The new Great Equalizer is the SEND button.
In Memory of Harv: Those who can make you believe absurdities can make you commit atrocities. ~Voltaire
|
|
Re: File Sharing, file is locked cannot save
|
|
Joined: Aug 2009
|
This isn't a permissions problem. Excel is recording the paths to files that are being edited (and therefore "locked"). You have to find that file and delete it.
(It's possible that instead of storing a list of paths, all in one file, it's instead creating a "lock" file alongside the file it thinks is in use. Same concept: find the lock file and delete it.)
I don't have Excel (nor any other Microsoft product) installed, so I can't look to see which method it uses. I'd first look for invisible files in the same folder as the "locked" file, paying close attention to files with similar names. Failing to find any of those, I'd use defaults read to look in Excel's preference file to see if it's keeping a locked file list in there.
|
|
Re: File Sharing, file is locked cannot save
|
|
Joined: Aug 2009
|
A post on Microsoft Answers suggests that the following procedure should work. (Untested) Open Terminal, and type: fyle= Do not type anything after the =; no spaces, no return character, nada. Drag the "locked" spreadsheet from Finder into the Terminal window. The line should read something like: fyle=/Users/... , with still no spaces around the =. Press return Enter the following command, this time pressing return at the end: rm -f "$(dirname "$fyle")/~\$$(basename "$fyle")"
|
|
Re: File Sharing, file is locked cannot save
|
Joined: Aug 2009
Likes: 15
|
Joined: Aug 2009
Likes: 15 |
Thanks for explaining what's really going on here.
The new Great Equalizer is the SEND button.
In Memory of Harv: Those who can make you believe absurdities can make you commit atrocities. ~Voltaire
|
|
|
|