Network and Storage Protocols

Excel shared workbook on CIFS

leekelley
5,939 Views

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.

1 ACCEPTED SOLUTION

leekelley
5,939 Views

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)

Read more: http://a2alpha.webnode.com/news/cifs-share-locked-files-on-a-netapp-filer/

View solution in original post

4 REPLIES 4

darraghos
5,939 Views

Hi,

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.

leekelley
5,940 Views

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)

Read more: http://a2alpha.webnode.com/news/cifs-share-locked-files-on-a-netapp-filer/

__jeremypage_3897
5,939 Views

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.

darraghos
5,939 Views

I ended up applying 7.2.3 P2 to resolve this issue

Public