Formatting Changes Not Updated in Linked Worksheet

Last reviewed: September 13, 1996
Article ID: Q109182
The information in this article applies to:
  • Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a, and 5.0
  • Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

If you link a worksheet from Microsoft Excel to Microsoft Word, formatting changes made in Microsoft Excel are not reflected in the linked table.

CAUSE

This behavior is by design; it allows you to update the linked information without losing the formatting you've applied in Microsoft Word.

WORKAROUND

To reflect formatting changes made to the worksheet in Microsoft Excel in the linked table in Microsoft Word, do the following:

  1. In Microsoft Word, select the linked worksheet.

  2. Press SHIFT+F9 to display the linked worksheet as a field code. The field code appears as follows

          {LINK Excel.Sheet.5 "Book1" "Sheet1!R1C1:R3C1" \a \r \* MERGEFORMAT}
    

    where Book1 is the name of the workbook, and Sheet1 is the name of the worksheet that is linked.

    NOTE: The information in the field code above will be different if the link is to a Microsoft Excel version 3.0, 4.0, or 4.0a worksheet; however, the following steps still apply.

  3. Delete the \* MERGEFORMAT switch from the field code so it appears as follows:

          {LINK Excel.Sheet.5 "Book1" "Sheet1!R1C1:R3C1" \a \r}
    

  4. With your cursor in the field code, press F9 to update the link, and press SHIFT+F9 to display the linked data.

The formatting of the field is now updated to the format of the worksheet in Microsoft Excel. However, any formatting you apply to the linked table in Microsoft Word is lost when you update the link.

MORE INFORMATION

Steps to Reproduce Behavior

  1. In a new worksheet, enter the following data:

          A1: apple
          A2: banana
          A3: orange
    

  2. In Microsoft Excel version 5.0, select cell A2, and choose Cells from the Format menu. Select the Font tab, and from the Font Style list, select Bold. Choose OK.

    In Microsoft Excel version 3.0, 4.0, or 4.0a, select cell A2, and choose Font from the Format menu. From the Font Style list (Style list in version 3.0), select Bold and choose OK.

  3. Select the range A1:A3 and choose Copy from the Edit menu.

  4. Run Microsoft Word and choose Paste Special from the Edit menu.

  5. From the As list (the Data Type list in version 2.0), select Formatted Text (RTF). Select the Paste Link option, and choose OK.

    The cells appear formatted as they were in Microsoft Excel.

  6. Switch to Microsoft Excel.

  7. Select cell A2, choose Delete from the Edit menu. Under Delete, select the Shift Cells Up option and choose OK.

  8. Switch back to Microsoft Word.

The third row in the table is empty, and orange appears in the second row as it should. However, orange appears with bold formatting instead of roman the way it is formatted in Microsoft Excel.


KBCategory: kbusage
KBSubcategory:

Additional reference words: 3.00 4.00 4.00a 5.00 7.00



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 13, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.