epmmis
asked on
Excel 2010 Message "<File Name>.xlsx is locked for editing by another user."
Setup: Excel 2010 on a Windows 2008 R2 Citrix 6.5 server.
User double clicks on the file and the message "<File Name>.xlsx is locked for editing by another user." The only options are to open it "read only", "notify" or "cancel". If the user closes other open Excel file this file can be successfully opened when double clicked on.
1. No other user is accessing the file.
2. The file can be successfully opened when it is opened using Excel's Open Menu option.
3. File is located on a Novell file share.
4. Situation happens most the times when multiple Excel files are opened. When there are mulitple files opened this error will often repeat.
5. It does infrequently happens when it is the 1st Excel file opened. When this happens closing/opening the file resolves this issue.
User double clicks on the file and the message "<File Name>.xlsx is locked for editing by another user." The only options are to open it "read only", "notify" or "cancel". If the user closes other open Excel file this file can be successfully opened when double clicked on.
1. No other user is accessing the file.
2. The file can be successfully opened when it is opened using Excel's Open Menu option.
3. File is located on a Novell file share.
4. Situation happens most the times when multiple Excel files are opened. When there are mulitple files opened this error will often repeat.
5. It does infrequently happens when it is the 1st Excel file opened. When this happens closing/opening the file resolves this issue.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Appreciate your suggestions, none of which got me any closer to resolving this issue. I do know that the user periodaccly has this issue when first opening a file to which no one has access. So not sure where to go with it now.
Awarding poinsts for your efforts.
Awarding poinsts for your efforts.
We have crazy problems with excel on the servers. I found unchecking the two suggested works somewhat. we have not found a permanent solution.
http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2012/05/14/the-definitive-locked-file-post.aspx
http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2012/05/14/the-definitive-locked-file-post.aspx
ASKER
I asked the user if it was possible/probable other users had previously opened these in use files.
His response was that this situation also happens with files in his home directory. Files which are exclusive to him.
He has not had a disconnected session when this event happens; a check is made when he reports this issue.
When a shared file is in use, the message will state “<File Name>.xlsx is locked for editing by <user name>."
Lastly, often times if the “Notify Me” button is pressed and the user waits about a minute; the in use file will become available for editing.