PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Setup
Re: "Excel file locked by [user]" though user is the one trying to open it!
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Setup
Re: "Excel file locked by [user]" though user is the one trying to open it!
![]() |
Re: "Excel file locked by [user]" though user is the one trying to open it! |
|
|
Thread Tools | Rate Thread |
|
|
#1 |
|
Guest
Posts: n/a
|
What temp directory are you clearing?
c:\windows\Temp C:\Temp C:\documents & Settings\<user>\local settings\temp Have you rebooted the server? "CheriD." <cdreke(removethis)@snocowac.org> wrote in message news:0D50AD38-3632-4E24-B197-559C6B590FA3@microsoft.com... : 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! : |
|
|
|
#2 |
|
Guest
Posts: n/a
|
I've tried clearing all the directories with disk cleanup and then manually. We've rebooted both the server and the client station. Sorry it took me so long to recheck this message!
----- Lady Layla wrote: ----- What temp directory are you clearing? c:\windows\Temp C:\Temp C:\documents & Settings\<user>\local settings\temp Have you rebooted the server? "CheriD." <cdreke(removethis)@snocowac.org> wrote in message news:0D50AD38-3632-4E24-B197-559C6B590FA3@microsoft.com... : 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 | |
| Rate This Thread | |
|
|

Main Page 

