Microsoft KB Archive/65069

Word: Pasted Cells from Excel Missing Columns or Data

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

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

= SUMMARY =

When you copy data from Microsoft Excel to a Word 4.0 or 5.0 document, values in cells that have a width of 0 in Excel will not be included in the pasted text.

This problem occurs because Word currently does not support pasting an Excel column with a width of 0. Thus, you must be able to see the information you want to copy from Excel (the Excel column must have a width greater than 0).

Microsoft is researching this problem and will post new information here as it becomes available.

= MORE INFORMATION =

When the data is pasted into Word, a column with a width of 0 in Excel will create an empty 1/8th-inch wide column in Word. This empty column will have the paragraph indents crossed (the indent markers on the ruler will be reversed).

You will not be able to change the width of this column by choosing Table Cells from the Format menu (in Word 4.0, choose Cells from the Format menu).

If you try to widen the column by choosing Table Cells from the Format menu (Cells in 4.0), you will receive one of the following error messages:

Word 5.0 ——–

Number must be between 0 and -0.01in

-or-

Word 4.0 ——–

Number must be between 0 and -0.014in

The number that this error message refers to is the Spacing Between Cols measurement. However, changing this value will not get rid of the error message. Choose the Cancel button to exit the dialog box.

To increase the column width so that you can enter data in it, do the following:


 * 1) If the ruler is not showing, choose Ruler from the View menu. (In Word 4.0, choose Show Ruler from the Format menu.)
 * 2) Select the column you want to make wider.
 * 3) Select Table Scale on the far-right of the ruler to activate the table ruler. (The table ruler is active when T’s appear in the ruler.)
 * 4) Hold down the SHIFT key and move the column marker that appears above the left border of the column you want to make wider.

This procedure causes the column border marker of the hidden column to appear in the ruler. The columns can then be adjusted individually. To change additional columns, repeat steps 1-4 above.

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