Microsoft KB Archive/49298

From BetaArchive Wiki

Word: Select All Cells When Updating Linked Information

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

====================================================================== 4.00 MACINTOSH kbusage kbdocerr

The information in this article applies to:
- Microsoft Word for the Macintosh, version 4.0

SUMMARY

Pages 386 and 409 of the “Reference to Microsoft Word” version 4.0 manual incorrectly state “To update information for particular columns or cells, select only those columns or cells.”

If you follow these instructions, columns or rows are added to the Word table, inserting those cell links not selected.

To update linked information between Word version 4.00 and Excel 2.20 using QuickSwitch, select the ENTIRE area to be updated on the Word document.

MORE INFORMATION

The following is an example:

  1. Create three columns by five rows in Excel linked to a table in Word that is also three columns by five rows (follow instructions on page 407 in Appendix C “Using Word with Other Applications.”)
  2. Change the data in the third column in Excel.
  3. Selecting only the last column in Word and choosing Update Link from the Edit menu enlarges the table to be five columns, repeating the first two columns. Instead, select all three columns of the table in Word before choosing Update Link. This will accurately update the third column.

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