Formatting Changes Not Updated in Linked Worksheet (109182)
The information in this article applies to:
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
This article was previously published under Q109182 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:
- In Microsoft Word, select the linked worksheet.
- 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.
- Delete the \* MERGEFORMAT switch from the field code so it appears as
follows:
{LINK Excel.Sheet.5 "Book1" "Sheet1!R1C1:R3C1" \a \r} - 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.
Modification Type: | Minor | Last Reviewed: | 8/15/2005 |
---|
Keywords: | KB109182 |
---|
|