Microsoft KB Archive/214345

= XL2000: Moved Cell Contents in Shared Workbook May Be Lost =

Article ID: 214345

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



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.

