Fix for filename is locked for editing by username Error

If you're new here, you may want to subscribe to Windows Reference RSS feed Thanks for visiting!

You receive an error message when you try to open some Excel 2003 files that are indexed on a Windows Server 2003-based computer.When you try to open some Microsoft Office Excel 2003 files that are indexed on a Windows Server 2003-based computer, you receive the following error message:

filename is locked for editing by username.
Click ‘Notify’ to open a read-only copy of the document and receive notification when the document is no longer in use.

Solution

Method 1

Exclude .xls files from being indexed. To do this, follow these steps.

Note:- You will be unable to use the Indexing Service to search Excel 2003 files after you exclude .xls files from being indexed.

Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall the operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

1.Start Registry Editor.
2.Locate and then click the following registry subkey:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\ContentIndex\Catalogs\Catalog Name\Scopes
3.Right-click Scopes, point to New, and then click String Value.
4.Type *.xls, and then press ENTER.
5.Double-click *.xls.
6.In the Value data box, type ,,4, and then click OK.
7.Close Registry Editor.

Method 2

This issue may only occur with some Excel 2003 files. Therefore, determine which Excel 2003 files are affected, and then move those files to a subfolder under the main content folder, if it is possible. Then, in the advanced folder properties for this folder, click to clear the For faster searching, allow indexing service to index this folder check box to exclude the folder from being indexed. The Indexing Service can then search the Excel 2003 files that are not corrupted. You can also disable Indexing for individual Excel 2003 files without changing the location.

Method 3

Save Excel 2003 files in the Microsoft Excel 97- Excel 2003 format.