Microsoft KB Archive/57192

Word: Paste Link Produces Table with Different # of Cells/Rows

PSS ID Number: Q57192 Article last modified on 03-07-1997

=
========================================================= 4.00 MACINTOSH kbinterop

= SUMMARY =

When a range of cells in which some cells overlap into other (empty) cells is selected in Excel version 2.20 and Paste Linked into Word version 4.00, an irregular table with a different number of cells in the rows is constructed.

This occurs because Excel and Word share formatting across the Clipboard, and since information was left in the overlapping cells in Excel, Word interprets the overlap as a merged cell. To correct the format of the table, put your cursor in the merged cell and choose Table from the Edit menu and click the Split Cell button.

= MORE INFORMATION =

For example, consider the following Excel spreadsheet section:

|--A--|--B--|--C--|--D--| 1| |West Coast |East Coast |South | 2|Sales | | | | 3|Service | | | | 4|Insurance Liabilities | | | 5|————-|————-|————-|————-|

Copying this table and Paste-Linking it into Word produces a table that has four columns in the first three rows and only three columns in the fourth row because the contents of cell A4 overlap into B4.

In the example above, if there is information in cell B4 preventing the text in A4 from overlapping, this situation will not occur.

Subsequently changing the column widths in Excel and updating the link does not change the table. The table must be Paste-Linked again for the table to have four cells in every row.

KBCategory: kbinterop KBSubCategory: kbtable Additional reference words: macword macword5 ====================================================================== ============================================================================= Copyright Microsoft Corporation 1997.