Incorrect "File in use" message when you try to open an Excel 2007 document from a remote shared folder on a computer that is running Windows Vista, Windows Server 2008, Windows 7 or Windows Server 2008 R2

Article translations Article translations
Article ID: 942146 - View products that this article applies to.
Expand all | Collapse all

On This Page

Symptoms

You open a remote shared folder in Windows Explorer that uses the Details view and for which the Preview Pane layout is enabled on a computer that is running Windows Vista, Windows Server 2008, Windows 7, or Windows Server 2008 R2. When you try to open a Microsoft Office Excel 2007 Workbook from the remote shared folder, you may receive the following message:
File in Use file_name is locked for editing by user_name

However, in this case, no other user is using this document.

Note This problem also occurs when you try to open other shared 2007 Office documents. Different users cannot exclusively edit such shared documents.

Resolution

To have us resolve the problem for you, go to the "Fix it for me" section.If you prefer to fix this problem yourself, go to the "Let me fix it myself" section.


Fix it for me

Collapse this imageExpand this image
assets folding start expanded
To fix this problem automatically, click the Fix it button or link. Then click Run in the File Download dialog box, and follow the steps in the Fix it wizard.

Collapse this imageExpand this image
assets fixit1
Fix this problem
Microsoft Fix it 51021
Collapse this imageExpand this image
assets fixit2

Notes
Collapse this imageExpand this image
assets folding start collapsed
  • If you are using Windows Vista or Windows Server 2008 without Service Pack 1 installed, please install the hotfix in the "Hotfix download available" section at the beginning of this Knowledge Base article before you run the Fix it solution.
  • This Fix it solution applies to both Office 2007 and Microsoft Office 2010.
  • This wizard may be in English only. However, the automatic fix also works for other language versions of Windows.
  • If you are not on the computer that has the problem, save the Fix it solution to a flash drive or a CD and then run it on the computer that has the problem.
  • We would appreciate your feedback. To provide feedback or to report any issues with this solution, please leave a comment on the "Fix it for me" blog or send us an email message.
Collapse this imageExpand this image
assets folding end collapsed

Collapse this imageExpand this image
assets folding end

Let me fix it myself

Collapse this imageExpand this image
assets folding start collapsed
To resolve this issue for Windows 7 and Windows Server 2008 R2, you can add the following registry keys:
  • Key: HKEY_CLASSES_ROOT\CLSID\{993BE281-6695-4BA5-8A2A-7AACBFAAB69E}

    Name: EnableShareDenyNone

    Type: REG_DWORD

    Value: 1
  • Key: HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{993BE281-6695-4BA5-8A2A-7AACBFAAB69E}

    Name: EnableShareDenyNone

    Type: REG_DWORD

    Value: 1
Note This setting applies to both Office 2007 and Office 2010.
Collapse this imageExpand this image
assets folding end collapsed

Service pack information

To resolve this problem, obtain the latest service pack for Windows Vista. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
935791 How to obtain the latest Windows Vista service pack

Hotfix information

A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix.

If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the hotfix.

Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site:
http://support.microsoft.com/contactus/?ws=support
Note The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language.

Prerequisites

No prerequisites are required.

Restart requirement

You must restart the computer after you apply this hotfix.

Hotfix replacement information

This hotfix does not replace any other hotfixes.

File information

The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.
Windows Vista, 32-bit versions
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Update.mumNot Applicable27,11805-Sep-200711:18Not Applicable
X86_microsoft-windows-propsys_31bf3856ad364e35_6.0.6000.20674_none_00b914b04a9af30b.manifestNot Applicable119,35805-Sep-200711:19Not Applicable
X86_microsoft-windows-shell32_31bf3856ad364e35_6.0.6000.20674_none_6a84d8d12e282864.manifestNot Applicable975,77205-Sep-200711:19Not Applicable
Propsys.dll6.0.6000.20674733,69605-Sep-200702:18x86
Shell32-ppdlic.xrm-msNot Applicable3,15005-Sep-200702:07Not Applicable
Shell32.dll6.0.6000.2067411,318,78405-Sep-200702:19x86
Windows Vista, 64-bit versions
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Amd64_microsoft-windows-propsys_31bf3856ad364e35_6.0.6000.20674_none_5cd7b03402f86441.manifestNot Applicable119,38205-Sep-200711:54Not Applicable
Amd64_microsoft-windows-shell32_31bf3856ad364e35_6.0.6000.20674_none_c6a37454e685999a.manifestNot Applicable977,91905-Sep-200711:54Not Applicable
Update.mumNot Applicable27,62905-Sep-200711:19Not Applicable
Wow64_microsoft-windows-shell32_31bf3856ad364e35_6.0.6000.20674_none_d0f81ea71ae65b95.manifestNot Applicable968,81905-Sep-200711:54Not Applicable
Propsys.dll6.0.6000.20674907,26405-Sep-200703:15Not Applicable
Shell32-ppdlic.xrm-msNot Applicable3,15005-Sep-200703:04Not Applicable
Shell32.dll6.0.6000.2067412,786,68805-Sep-200703:16x64
Shell32.dll6.0.6000.2067411,318,78405-Sep-200702:19x86

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in Windows Vista Service Pack 1.

More information

If you use the 2007 Office system, you must add following registry keys after you install this hotfix.
  • Key:
    HKEY_CLASSES_ROOT\CLSID\{993BE281-6695-4BA5-8A2A-7AACBFAAB69E}

    Name: EnableShareDenyNone
    Type: REG_DWORD
    Value: 1
  • Key:
    HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{993BE281-6695-4BA5-8A2A-7AACBFAAB69E}

    Name: EnableShareDenyNone
    Type: REG_DWORD
    Value: 1
Save the following text as a .reg file, and then and double click the file.
Windows Registry Editor Version 5.00 
[HKEY_CLASSES_ROOT\CLSID\{993BE281-6695-4BA5-8A2A-7AACBFAAB69E}] 
@="Microsoft Office Metadata Handler" 
"EnableShareDenyNone"=dword:00000001 
[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{993BE281-6695-4BA5-8A2A-7AACBFAAB69E}] 
@="Microsoft Office Metadata Handler"
"EnableShareDenyNone"=dword:00000001 
Note: The components affecting the issue has been updated on Windows 7 and Windows Server 2008 R2, however, to fix the problem the above registry entries have to be made on Windows 7 and Windows Server 2008 R2 machines as well.

For more information, click the following article number to view the article in the Microsoft Knowledge Base:
822227 Program may raise a sharing violation when a file is opened from Windows Explorer
For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates

Properties

Article ID: 942146 - Last Review: August 7, 2014 - Revision: 6.0
Applies to
  • Windows Vista Business
  • Windows Vista Enterprise
  • Windows Vista Home Basic
  • Windows Vista Home Premium
  • Windows Vista Ultimate
  • Windows Vista Enterprise 64-bit Edition
  • Windows Vista Home Basic 64-bit Edition
  • Windows Vista Home Premium 64-bit Edition
  • Windows Vista Ultimate 64-bit Edition
  • Windows Vista Business 64-bit Edition
  • Windows Server 2008 Datacenter
  • Windows Server 2008 Enterprise
  • Windows Server 2008 Foundation
  • Windows Server 2008 Standard
  • Windows 7 Enterprise
  • Windows 7 Home Basic
  • Windows 7 Home Premium
  • Windows 7 Ultimate
  • Windows Server 2008 R2 Datacenter
  • Windows Server 2008 R2 Enterprise
  • Windows Server 2008 R2 Foundation
  • Windows Server 2008 R2 Standard
Keywords: 
kbautohotfix kbvistasp1fix kbexpertisebeginner kbbug kbfix kbhotfixserver kbqfe KB942146

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com