Microsoft KB Archive/293280

= WD2001: Fields Appear on Same Line When You Merge Data from Excel Workbook =

Article ID: 293280

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Word 2001 for Mac
 * Microsoft Excel 2001 for Mac

-



This article was previously published under Q293280



SYMPTOMS
When you merge a data document that contains 63 or more fields and you insert the fields, all of the fields from field 63 and greater appear on the same line and cannot be inserted separately.



CAUSE
Word 2001 has a limitation of 63 columns in a table. When data is imported from Excel 2001 to Word 2001, the data is converted into a table.



WORKAROUND
To work around this behavior, do one of the following:


 * Export the data from Excel in a comma-delimited format.

-or-
 * Modify the data document to fewer than 63 fields.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
To export the data into a new document in the comma-delimited format, follow these steps:  In the Excel workbook, click Save As on the File menu.

NOTE: To create a copy of the workbook, type a different name in the Name box. On the Format menu, select CSV (comma delimited), and then click Save. When the following message appears, click OK:

The Selected file type does not support workbooks that contain multiple sheets.

To save only the active sheet, click OK.

To save all sheets, save them individually using a different file name for each, or choose a file type that supports multiple sheets.

 After you click OK in the preceding message, the following message appears. Click Yes in this message:

may contain features that are not compatible with CSV (Comma delimited). Do you want to keep the workbook in this format?

To keep this format, which leaves out any incompatible features, click Yes.

To preserve the features, click No. Then save a copy in the latest Excel format.



Additional query words: mac macword WD2001KB merge data DDE OLE 63 field one line DMM excel XL2001 document WD2001 garbage

Keywords: kbbug kbpending KB293280

-

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

© Microsoft Corporation. All rights reserved.