A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Excel file locked by [user]" though user is the one trying to open it!



 
 
Thread Tools Display Modes
  #1  
Old May 11th, 2004, 09:21 PM
CheriD.
external usenet poster
 
Posts: n/a
Default "Excel file locked by [user]" though user is the one trying to open it!

We are using Office XP with SP2 running on Windows 2000 workstations w/SP4. I have an Excel file on a network share (Windows 2000 Server w/SP 4) which has special permissions:
* Two users have full control (let's call them Terry and Jerry), along with administrator
* All other users have read and execute permissions

Every couple weeks when Terry and Jerry (they don't use the file at same time) try to open the file, it says "File is in use by [themself]" and it's locked, though they haven't opened it since day before when it worked fine. I have verified no one else is in the file at all and it's absolutely not open anywhere else. Our antivirus software on server is not running a scan during the time and is not accessing the file (both server side and workstation side), nor are any backups running during the day. I have tried clearing temp files on the workstations and on the server share, I have tried rebooting computer, and also tried everything I could find on file locks in MS knowledge base, but to no avail. The only way they can once again use the file is to open it read only, then to do a Save As with another name. I have even tried to access file from server and to rename or open it there, but receive same error message. I can't find any common reasons for why it is fine for a while then randomly becomes locked. Sometimes it happens in a couple days, sometimes every couple weeks. Any help to correcting this issue would be appreciated. Thanks!

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:26 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.