An open community 
of Macintosh users,
for Macintosh users.

FineTunedMac Dashboard widget now available! Download Here

Topic Options
#17463 - 09/18/11 09:18 AM File Sharing, file is locked cannot save
kevs Offline


Registered: 12/07/09
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!

Top
#17466 - 09/18/11 02:40 PM Re: File Sharing, file is locked cannot save [Re: kevs]
tacit Offline


Registered: 08/03/09
Loc: Portland, Oregon, USA
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

Top
#17467 - 09/18/11 03:23 PM Re: File Sharing, file is locked cannot save [Re: tacit]
kevs Offline


Registered: 12/07/09
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.

Top
#17469 - 09/18/11 05:07 PM Re: File Sharing, file is locked cannot save [Re: kevs]
joemikeb Offline

Moderator

Registered: 08/04/09
Loc: Fort Worth, Texas
The server is the computer the file is located on. It is "serving" as a file storage device.
_________________________
joemikeb • moderator

Top
#17470 - 09/18/11 06:51 PM Re: File Sharing, file is locked cannot save [Re: joemikeb]
kevs Offline


Registered: 12/07/09
Joe, thanks!
So what should unlock this? A reboot of the computer? something else?

Top
#17471 - 09/18/11 07:01 PM Re: File Sharing, file is locked cannot save [Re: kevs]
artie505 Online


Registered: 08/04/09
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.


Edited by artie505 (09/19/11 03: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

Top
#17475 - 09/19/11 05:57 AM Re: File Sharing, file is locked cannot save [Re: kevs]
joemikeb Offline

Moderator

Registered: 08/04/09
Loc: Fort Worth, Texas
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.
_________________________
joemikeb • moderator

Top
#17478 - 09/19/11 08:14 AM Re: File Sharing, file is locked cannot save [Re: joemikeb]
kevs Offline


Registered: 12/07/09
JOe, did log out, reboot and the shutdown, and the file is still locked. thanks.

Top
#17479 - 09/19/11 11:07 AM Re: File Sharing, file is locked cannot save [Re: kevs]
Virtual1 Offline


Registered: 08/04/09
Loc: Iowa
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

Top
#17496 - 09/19/11 05:07 PM Re: File Sharing, file is locked cannot save [Re: Virtual1]
kevs Offline


Registered: 12/07/09
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.

Top
#17497 - 09/19/11 05:07 PM Re: File Sharing, file is locked cannot save [Re: kevs]
kevs Offline


Registered: 12/07/09
PS, and doing a save as to a new name does not work!

Top
#17498 - 09/19/11 05:14 PM Re: File Sharing, file is locked cannot save [Re: kevs]
kevs Offline


Registered: 12/07/09
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.


Top
#17500 - 09/19/11 05:23 PM Re: File Sharing, file is locked cannot save [Re: kevs]
artie505 Online


Registered: 08/04/09
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

Top
#17505 - 09/20/11 09:54 AM Re: File Sharing, file is locked cannot save [Re: artie505]
ganbustein Offline


Registered: 08/04/09
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.

Top
#17507 - 09/20/11 10:17 AM Re: File Sharing, file is locked cannot save [Re: ganbustein]
ganbustein Offline


Registered: 08/04/09
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")"


Top
#17511 - 09/20/11 12:15 PM Re: File Sharing, file is locked cannot save [Re: ganbustein]
artie505 Online


Registered: 08/04/09
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

Top

Moderator:  alternaut, dkmarsh, joemikeb