The File is locked for Editing
Posted on 2013-06-14
I am having an issue accessing Excel documents saved on a Network drive, located on a Small Business Server 2011. Documents are created in Office 2010 on Windows 7 machines. The problem is accessing the Documents from Mac's running Office 2011 v14.3.5, which I just updated to try to resolve the problem. The problem is random, does not happen on all documents all the time. The work around has been to go to the machine that has reportedly locked the file, do a "save as" as a different name, delete the original and then all machines can access for a period of time.
Here are some steps I have taken from posts I have read regarding this issue;
-Change Owner of the shared folder to Domain\User full control
-Use the Open and repair tool from within Excel
-Run a Compatibility check from Excel 2011 Mac, which returns a report stating "Workbook contains features not available in earlier versions of Excel"
Recent workaround, I saved as Excel 97-2003 Workbook, seems to be working for time being.
Please advise if anyone else has experienced this and have found a solution.