XL2000: Moved Cell Contents in Shared Workbook May Be Lost (214345)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q214345

SYMPTOMS

If you move a cell (by using the drag-and-drop feature or by using the Cut and Paste commands) in a shared workbook, the contents of the moved cell may be lost when you immediately save the shared workbook. This behavior may occur even when you move the cell to a location that is not available to all users of the shared workbook.

CAUSE

This behavior can occur when the following conditions are true:
  • Both you and another user open the shared workbook.

    -and-
  • The other user clears the contents of a cell (by pointing to Clear on the Edit menu and clicking Contents) and saves the shared workbook.

    -and-
  • You move another cell (by using the drag-and-drop feature or by using the Cut and Paste commands) to the location that was cleared by the other user, and then you save the shared workbook.

RESOLUTION

Before you clear the contents of a cell, use the Copy and Paste commands to make a backup copy of the cell. Then, to clear the contents of the original cell, select it, point to Clear on the Edit menu, and click Contents del.

MORE INFORMATION

When you save a shared workbook, Microsoft Excel 2000 first updates the changes from the most recent save on the shared workbook, and then saves your changes. If a cell is cleared in the previous save and you moved that same cell, the cleared cell is moved to the new location.

REFERENCES

For more information about shared workbooks, click Microsoft Excel Help on the Help menu, type limitations of shared workbooks in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MajorLast Reviewed:9/27/2003
Keywords:kbprb KB214345
©2003 Microsoft Corporation. All rights reserved.