I’ve been trying everything; this is the last chance I have.
I moved folders and files from an old Windows Server 2003 File Server to a new FS (Win Server 2008 R2) with DFS and ABE enabled.
Now, a specific Shared Excel file is driving me crazy, out of a sudden, lots of times per day, users are getting the following error while opening that file:
Filename.xlsx is locked for editing by ‘another user’. Open ‘Read-Only’ or, click ‘Notify’ to open..
I’ve already followed this, with no joy:
http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2012/05/14/the-definitive-locked-file-post.aspx
In any case, I strongly think this is not client-related, since it never gave that problem in the past with Windows Server 2003. I’ve found and followed many other solutions, nothing.
The users are all utilizing Office 2010 on Windows 7 machines, besides a few users who are still on Windows XP machines.
I appreciate any help, thank you!
Best Answer
This has to do with the new Trust Settings that are in Office 2010. From the File menu, select Options and then select Trust Center. Then select the File Block Settings. Make sure you have most of the checkboxes cleared. I have only Word 95, 6.0 and Word 2 and earlier set for Open. All the rest of the documents I leave alone. I also have the Open behavior set for Open selected file types in Protected View.
These file types can have macro virus' in them that perhaps the macro checker would not find since they use Word Basic rather than the newer macro controls.