General discussion

Locked

excel shared file problem

By dave the IT guy ·
I have a shared excel doc that two users on my Windows 2000 LAN need to access at the same time. I have set up a sharepoint and have supplied Full Access share and NTFS permissions to the file. Both users have this file open on their desktops all day and both make changes to the file. Everything was working fine until one day, out of the blue, they both received error messages on morning indicating that the file was in use and "locked for editing" and that they could only open a read-only copy of the file. Neither of them had the file open. When I checked the server - there was no indication that the file was in use anywhere else on the network. A reboot of the server fixes the problem, but this is the third time it has happened in the past 2 months and I don't like rebooting our primary file server in the middle of the day to fix the problem - any suggestions?

This conversation is currently closed to new comments.

9 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by sgt_shultz In reply to excel shared file problem

does this file show up in (right-click) My Computer/Manage/Shared Folders/Open Files when this happens. if it does maybe you can close it there without rebooting...

Collapse -

by dave the IT guy In reply to

No - it doesn't show up anywhere - the file thinks it is open, but there is no indication in the network that it is.

Collapse -

by gdh19701 In reply to excel shared file problem

You mention they both have full access to the file share location and NTFS permissions to the file. Are there any restrictions further up in the directory tree where one or both users do not have write permissions?

My other thought is to verify within Excel that the sharing property is still in effect. You can have one user open the Excel spreadsheet > Tools > Share Workbook > Sharing > Edit tab and verify the "Allow changes by more than one user at the same time" is still selected. You might uncheck and recheck to verify the shared setting of the spreadsheet, and then save the document.

You mention both users access this same file pretty much 9x5. There has to be some period where the system(s) can refresh the properties of the document, even if it's done as versioning of the file.

One last thought is if the users connect to the file via VPN or RAS, and haven't terminated their sessions. If they log on a home or on the road to access this file, and don't close the document when completed, then they will get the locked error. You will need to confirm this with them. I would also consider disconnecting the network shares from each user's machine, and shutdown/restart and remap the drives (unless done automatically by a login script).

Hope this helps

Collapse -

by dave the IT guy In reply to

Thanks for your thoughts - as to the permissions - if that were the problem, a reboot of the server wouldn't fix it - and it does. I have gone into the document and double-checked the settings on the file - everything is as it should be. I have turned it off and back on several times all to no avail. The file is set to autosave changes every 5 minutes so that they can see each others changes. Neither user accesses this file remotely. Any other thoughts?

Collapse -

by gdh19701 In reply to excel shared file problem

Searching throught the Microsoft Knowledge Base, I found an article that may address your situation. If the server this document resides on is also being used as a web server, or has Office Server Extensions installed/running, the shared workbook actually acts as an "unshared" workbook, which causes the file lock to happen.

Shared workbooks do not work as expected on Web servers; they behave the same as "unshared" workbooks. That is to say, at any given time only one user will be able to open the workbook for editing (Read-Write), all other users can only open the file as Read-Only.

So, if the server this file is saved on is also running IIS or Exchange server, chances are this condition will persist.

You will need to save the document (even from Read-Only Mode) as a new file, and disable the sharing property (not really an option for you since you have 2 users needing full-time access), or save it to another server that is not running Office Extensions.

And yes, two last thoughts, actually-- 1) do the users logoff/shutdown their systems (thereby closing the Excel APPLICATION) when they leave for the day? and 2) have you tried performing a Detect & Repair from the application's help menu?

hope this helps again...

Collapse -

by gdh19701 In reply to

oops.. forgot to include the KB article from Microsoft's website:

http://support.microsoft.com/default.aspx?scid=kb;en-us;229483

Collapse -

by dave the IT guy In reply to

The server is a web server, but has been running as a web server for over a year - this problem is only about 2 months old. The server is not running Office Extensions. They both powerdown their systems at night, and Detect & Repair couldn't find anything to repair.

Collapse -

by whitsell In reply to excel shared file problem

I have this same problem. Both server are file servers and I have windows XP as my client machines.

Did yoy find any answers?

Collapse -

by dave the IT guy In reply to

I haven't got a definitive answer, but something that has been working for a few days in a row so far is this...
I have had the users not open other Excel files in the same session of Excel as the shared file. If they need other Excel files, I have them open a second instance of Excel and use that throughout the day for other Excel work. This seems to be working - but like I said, it has only been a few days.

Back to Software Forum
9 total posts (Page 1 of 1)  

Related Discussions

Related Forums