Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. "You are no longer connected to this file" error when you save a shared Excel workbook

"You are no longer connected to this file" error when you save a shared Excel workbook

View products that this article applies to.

Symptoms

When you try to save a shared workbook in Microsoft Excel, you receive the following error message:

You are no longer connected to this file. Another user may have removed you from it, or saved over it.

To preserve your unsaved work, click OK, and save the shared workbook with a different name. You can then open the original shared workbook again, and merge in your changes from the copy of the workbook that you saved.

For information about merging workbooks, click Help.

↑ Back to the top

Cause

This problem may occur when the following conditions are true:
  • The workbook is a shared workbook that's saved on a UNC share.
  • The file is currently opened by another user on a different computer.
  • You opened the file by using a mapped drive on your current computer. 
  • Your current computer has the following registry value set:

    [HKCU or HKLM]\Software\Microsoft\Office\[12.0 or 14.0]\Word\Options
    (DWORD) "VolumePref" = 2
  • No other user has made changes to the workbook since you opened it and before you tried to save it.

This problem occurs when the volume preference option (VolumePref) is set to the opposite value from its setting when you opened the workbook. In this case, it was set to prefer UNC when you opened the workbook by using the mapped drive letter. The setting applies to code in the shared Office library, but it was originally meant to apply only to Microsoft Word. 

Note This setting is largely obsolete, but it is still maintained for backward compatibility. However, it can interfere with shared workbook authorship settings, and this prevents authored changes from being saved. 

↑ Back to the top

Resolution

To resolve this issue, remove the VolumePref setting, or change value to zero (the default).

↑ Back to the top

Keywords: kbsurveynew, kbtshoot, kbexpertiseinter, kb

↑ Back to the top

Article Info
Article ID : 2744335
Revision : 1
Created on : 1/7/2017
Published on : 4/29/2015
Exists online : False
Views : 1163