The information in this article applies to:
SYMPTOMSIf 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 may occur even when you move the cell to a location that is not used for all users of the shared workbook. CAUSE
This behavior occurs when the following conditions are true:
-and- -and- RESOLUTIONUse the Copy and Paste commands to make a copy of the contents of the cell. You can clear the contents of the original cell. With the original cell selected, point to Clear on the Edit menu and click Contents to clear the contents of the original cell. MORE INFORMATIONWhen you save a shared workbook, Microsoft Excel will update the changes from the last save on the shared workbook first and then save 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 the Office Assistant,
type "Shared Workbook," click Search, and then click to view "What you
need to know about working in a shared workbook." Q120802 Office: How to Add/Remove a Single Office Program or Component Additional query words: XL97 drag drop
Keywords : xlwgroups |
Last Reviewed: September 16, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |