Anyways, you should ask another person to close Excel file correctly or give you a needed permission for editing Excel documents. Do not forget, that you can still have access to the document in the mode “read-only”. Make sure that another co-author has closed Excel file on all his devices. If Excel document has been locked by someone else with whom you co-author, you should get in contact with the person and try to solve this issue together.
#NETWORK EXCEL FILE LOCKED FOR EDITING WINDOWS#
This post applies to Windows 10, 7, 8, Server 2008, and Server 2012. Now if you have the other user close the application, then re-open the file, they should be able to edit it without a locking issue. Find the file that is locked, then right-click it and choose Close Open File. User2 closes excel, then user3 goes in and gets the lock message. On the next screen, expand the list of Open Files > right-click on the Locked Excel File and click on Close Open File option. Expand Shared Folders, then select Open Files. There are times where user1 will access a file, and user2 will wait a few minutes, go in and they do not see an lock message.
#NETWORK EXCEL FILE LOCKED FOR EDITING WINDOWS 7#
On a Windows Vista or Windows 7 computer, you may see a File in use or Filename is locked for editing by username message when opening a Microsoft Office document (e.g., Excel or Word file) in a remote shared folder in Windows Explorer that used the Details view and the Preview Pane layout. And with that, those issues are not happening 100% of the time on file server 1. THE INFORMATION IN THIS ARTICLE APPLIES TO: WAFS, all versions SYMPTOM. The app server doesn't seem to come into the equation, but file server 2 does not exhibit the same issues as file server 1. When a user on the network opens the file in Excel, the file is locked for editing - this is the expected behavior. the effect is the same as the file locking we saw with shared network drives in the. A open file session is never created for user2 on the file server, but they see and work as though all is normal. We are using Excel 2010 and sometimes users are working from a network share. Open the Excel file in Excel or Excel online Edit the Excel file Save the Excel file Check in the Excel file and make a comment about what you changed Checking out an Excel file from SharePoint means that nobody else can edit it during this time, i.e. So they go in, make their changes, save out and close the file. user2 goes to open that same file, and does NOT get a message that the file is locked for editing message. But, NOT SO, of course i am the only user logged in to. So they go in, make their changes, save out and close the file. Situation: user1 opens up an excel file that is on server1 and starts to work. I am getting a message, the Excel file i am opening (xlsm) is locked for editing by 'another user'. user2 goes to open that same file, and does NOT get a message that the file is 'locked for editing' message. Situation: user1 opens up an excel file that is on server1 and starts to work. Current setup: 3 app servers (2008 r2, terminal services XenApp 6.5), 2 file servers (2008 r2).