Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

The Link field links information from another application to your Word document by using OLE. Microsoft Word inserts this field when you copy information from another application and paste it into a Word document by using the Paste Special command (Home tab, Clipboard group, Paste command arrow button).

Security Note: Because field codes can be visible to anyone reading your document, be sure that the information you place in field codes is not information that you want kept private.


When you view the FieldName field in your document, the syntax looks like this:

{ LINK ClassName "FileName" [PlaceReference ] [Switches ] }

Note:  A field code tells the field what to show. Field results are what’s shown in the document after having evaluated the field code. To toggle between viewing the field code and the field code results, press Alt+F9.



The application type of the linked information. For example, for a Microsoft Excel chart, ClassName is "Excel.Chart.8." Word determines this information from the source application.


The name and location of the source file. If the location includes a long file name with spaces, enclose it in quotation marks. Replace single backslashes with double backslashes to specify the path, for example:



Identifies the portion of the source file that's being linked. If the source file is a Microsoft Excel workbook, the reference can be a cell reference or a named range. If the source file is a Word document, the reference is a bookmark.



Updates the LINK field automatically; delete this switch to use manual updating.


Inserts the linked object as a bitmap.


Graphic data isn't stored with the document, thus reducing the file size.


Causes the linked object to update its formatting in a particular way, according to one of the following parameters.

This value



Maintain the formatting of the source file


Not supported


Match the formatting of the destination document


Not supported


Maintain the formatting of the source file, if the source file is an Excel workbook


Match the formatting of the destination document, if the source file is an Excel workbook


Inserts the linked object as HTML format text.


Inserts the linked object as a picture.


Inserts the linked object in rich-text format (RTF).


Inserts the linked object in text-only format.


Inserts the linked object as Unicode text.


The following example inserts a range of cells from a Microsoft Excel worksheet. The \a switch ensures that the information is updated in Word whenever the worksheet is changed in Microsoft Excel:

{ LINK Excel.Sheet.8 "C:\\My Documents\\Profits.xls" "Sheet1!R1C1:R4C4" \a \p }

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!