2011-01-19 11:24 AM
Are there know issues with utilizing MS Excel "Shared" workbook on CIFS. We are receiving an error that the file is locked, but I have verified with the Lock Status from the filer that the file is NOT locked. I have terminated the user session in a last ditch attempt to unlock the file, but this also did not release the lock. I am aware that I can terminate and restart the CIFS during non production hours, but would like to know if this issue was caused by the fact that this is a "Shared" Excel workbook.
Solved! SEE THE SOLUTION
2011-09-22 09:23 AM
I have a similar issue with Excel 2007 running on windows 7. A Shared workbook will be access by a user. They will close out of it and save some changes. Thye may open it later to be told that they themselevs have it locked for editing. When i check on the filer there is an oplock open against that machine and user for the file. I think this is an issue with windows 7 not releasing the lock rather than the filer but i'll post here in case anyone has information about it.
2011-09-22 09:52 AM
Thank you for your post...
Although on the NetApp Filer when executing the lock status command, did not show the file status as locked, I was able to unlock the file with the command below, utilizing lock break owner..
lock break -o owner [-f file] [-p protocol] (valid for CIFS only)
2011-10-12 09:32 AM
You also may want to try using the Windows Management MMC to do this
1) Right Click on My Computer & select Manage
2) Right Click on COmputer Managment (Local) and select Connect to another computer...
3) Enter the name of the filer
4) Drill down to Shared Folders > Open FIles
You should be able to close files from here. May be easier for some folks than using SSH.