Microsoft KB Archive/870752

= Workbook data does not merge as expected in Excel 2002 =

Article ID: 870752

Article Last Modified on 11/2/2004

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition

-





SYMPTOMS
When you merge data into a Microsoft Excel 2002 workbook, data may not appear in the correct cell.



CAUSE
This behavior occurs if you have previously merged the same file into the current workbook.



WORKAROUND
To work around this behavior, share the current workbook, and then merge the workbook again. To share a workbook in Excel 2002, follow these steps:
 * 1) Start Excel, and then open the file you want.
 * 2) On the Tools menu, click Share Workbook.
 * 3) Click to select the Allow changes by more than one user at the same time. This also allows workbook sharing check box, and then click OK.



MORE INFORMATION
Excel 2002 is designed to merge a workbook one time. Excel 2002 ignores changes that you made to a workbook after the initial merge when you merge a workbook again. Changes made to a workbook may be merged as new data in the wrong cell.

Keywords: kbtshoot kbbug kbprb KB870752

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.