Workbook data does not merge as expected in Excel 2002 (870752)


The information in this article applies to:

  • Microsoft Excel 2002

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.
Modification Type:MajorLast Reviewed:11/2/2004
Keywords:kbtshoot kbBug kbprb KB870752 kbAudEndUser
©2004 Microsoft Corporation. All rights reserved.