Knowledgebase: Microsoft Word
WD2000: MERGEFORMAT Switch Is Removed When You Change the Source of Link Field
Posted by - NA - on 23 March 2006 08:30 AM
Solution:

1. In your Word document, press ALT+F9 to turn on the Link field code. You should see a Link field similar to the following:
{LINK Excel.Sheet.8 "C:\\My Documents\\BOOK2.XLS" "Sheet1!R1C1" \a \r}
2. Add the MERGEFORMAT switch to the Link field. The Link field should look similar to the following:
{LINK Excel.Sheet.8 "C:\\My Documents\\BOOK2.XLS" "Sheet1!R1C1" \a \r \* MERGEFORMAT}
3. Press ALT+F9 to turn off the field codes.

To change the source of a Link field in Word, follow these steps:
1. On the Edit menu, click Links.
2. In the Links dialog box, click Change Source.
3. In the Change Source dialog box, click the file that you want to update your Link field, and then click Open.
4. Click OK to close the Links dialog box.
(105 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
Help Desk Software by Kayako Fusion