Microsoft KB Archive/65030

Word: Edit or Update Link Inserts Tab-Delimited Worksheet

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

=
========================================================= 4.00 5.00 MACINTOSH kbinterop kb3rdparty kbole

= SUMMARY =

When performing an update or edit link on a Microsoft Excel worksheet that has been paste linked into Microsoft Word for the Macintosh version 4.0 or 5.0, you may receive the following warning:

Mixed table/text selection. Shrinking replacement area

This warning indicates that additional text was selected along with the table linked to the Excel worksheet.

If you ignore this warning by choosing OK, two things may happen:


 * The update or edit will be performed correctly. This will happen if the extra selected text was located below the table.
 * A tab-delimited copy of the spreadsheet information will be inserted between the header and the table. This will happen if the extra text was between the header information that identifies the Excel worksheet and the table that was linked to the worksheet.

Note: In Word 5.0 under System 6.0x ONLY, the Link Options command will be dimmed if the document was linked using Word 4.0. In Word 5.0, to update the links of a Word 4.0 document in System 6.0x the following commands must be added to the menu:

Edit QuickSwitch Paste Link Update Link

The reason for adding these commands results from the difference in which linking was done in Word 4.0 and 5.0. To update the link of a Word 4.0 document opened in 5.0 in System 6.0x, do the following:


 * 1) Select both the header information and Excel document that was paste linked.
 * 2) From the Edit menu, choose Update Link.

KBCategory: kbinterop kb3rdparty kbole KBSubCategory: kbtable Additional reference words: macword macword5 4.00 5.00 grayed greyed unavailable QuickSwitch ====================================================================== ============================================================================= Copyright Microsoft Corporation 1997.