Insert data in text from file
Use this function to insert data from separate Excel cells into the body text in your Word document and constantly refresh it at a click.
This is how you insert a data in text object directly from a file into Word with firesys:
-
In Excel, highlight the cell that you want to add to Word as a linked data object in the body text.
-
Give the selected cell a name as otherwise it cannot be imported.
-
Save the Excel file.
-
Repeat this procedure for each cell that you want to add to Word as a linked data object in body text.
-
Go to Word and position the cursor where you want to insert the data in the document.
-
On the “*Content” tab in the “Excel Data” group on the “Insert” menu and select “From file” from the “Data in text...” area.
→ A data selection dialogue opens.. -
Select the Excel file containing the worksheet with the cell you require (“data source”).
→ The linktext assistant opens -
The linktext assistant opens.
-
Select the worksheet containing the required cell.
-
Select the cell using the name that you defined in Excel.
-
If applicable, check “Set absolute value” if you want to add a number as an absolute value.
-
Click on "OK".
→ The linktext assistant inserts the data from the selected Excel cell into your body text.
See also
An overview of inserting Excel contents
Insert a table directly from the selected Excel range
Insert data in text from a file
Insert data in text directly from the selected Excel cell
Insert data in text directly from the selected Excel cell with options