How to automatically update Excel fields in Word 2003

A Microsoft Excel file is displayed as a table.

Columns on the worksheet are also known as fields and often contain information lines. Although you can use an Excel file to a mail merge in Word 2003, you can change your fields in the mail merge not. The two files, to the other side by pasting from Excel into a Word document file and the binder. This allows you to work directly with Excel directly from within by Word fields. Level of difficulty: Moderately easy

Instructions

1. 1

   Open the worksheet that contains the fields in Microsoft Excel.

2

Select the data (rows and columns) that you want to use.

Select "Copy" in the "Standard" toolbar or press "CTRL + C" on your keyboard to copy the selected data.

3

To minimize a minimum of Microsoft Excel, then open a new or existing Word 2003 document.

4

To set the insertion point where you Excel fields appear in your document to.

5

Select "Edit" and "Paste Special" in the toolbar dialog box "Paste Special" open

6

Select "Microsoft Office Excel worksheet object" and select "Insert link."

Click "OK".

7

Double-click the Excel object on your page, open the spreadsheet directly in Word.

You will be redirected to Excel. To update a field, then name it, new format it or change. Press "CTRL + S", the mo speichernNGES and close the Excel file.

8

Click outside the object

in Word, to see the updates on your page.