An open community 
of Macintosh users,
for Macintosh users.

FineTunedMac Dashboard widget now available! Download Here

Previous Thread
Next Thread
Print Thread
File Sharing, file is locked cannot save
#17463 09/18/11 04:18 PM
Joined: Dec 2009
kevs Offline OP
OP Offline

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
kevs #17466 09/18/11 09:40 PM
Joined: Aug 2009
Likes: 1
Offline

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.


Photo gallery, all about me, and more: www.xeromag.com/franklin.html
Re: File Sharing, file is locked cannot save
tacit #17467 09/18/11 10:23 PM
Joined: Dec 2009
kevs Offline OP
OP Offline

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
kevs #17469 09/19/11 12:07 AM
Joined: Aug 2009
Likes: 16
Moderator
Online
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
joemikeb #17470 09/19/11 01:51 AM
Joined: Dec 2009
kevs Offline OP
OP Offline

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
kevs #17471 09/19/11 02:01 AM
Joined: Aug 2009
Likes: 15
Online

Joined: Aug 2009
Likes: 15
Originally Posted By: tacit
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
kevs #17475 09/19/11 12:57 PM
Joined: Aug 2009
Likes: 16
Moderator
Online
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
joemikeb #17478 09/19/11 03:14 PM
Joined: Dec 2009
kevs Offline OP
OP Offline

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
kevs #17479 09/19/11 06:07 PM
Joined: Aug 2009
Offline

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
Virtual1 #17496 09/20/11 12:07 AM
Joined: Dec 2009
kevs Offline OP
OP Offline

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
kevs #17497 09/20/11 12:07 AM
Joined: Dec 2009
kevs Offline OP
OP Offline

Joined: Dec 2009
PS, and doing a save as to a new name does not work!

Re: File Sharing, file is locked cannot save
kevs #17498 09/20/11 12:14 AM
Joined: Dec 2009
kevs Offline OP
OP Offline

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
kevs #17500 09/20/11 12:23 AM
Joined: Aug 2009
Likes: 15
Online

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
artie505 #17505 09/20/11 04:54 PM
Joined: Aug 2009
Offline

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
ganbustein #17507 09/20/11 05:17 PM
Joined: Aug 2009
Offline

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
ganbustein #17511 09/20/11 07:15 PM
Joined: Aug 2009
Likes: 15
Online

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

Moderated by  alternaut, dkmarsh, joemikeb 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.4.33 Page Time: 0.029s Queries: 46 (0.023s) Memory: 0.6432 MB (Peak: 0.7580 MB) Data Comp: Zlib Server Time: 2024-03-28 20:17:41 UTC
Valid HTML 5 and Valid CSS