After you’ve created a named range for the OfficeConnect for Excel data you want to use in your Word document, you’re ready to establish the connection between the OfficeConnect for Excel workbook and the Word document. Note that you can also connect the OfficeConnect for Word document with named ranges in a regular Excel file.
To create the connection to the OfficeConnect for Excel file:
In OfficeConnect for Word, open the Word document you want to connect with the OfficeConnect for Excel workbook.
This can be a new or existing Word document.
On the OfficeConnect tab, in the External Data group, click Link to Workbook.
The Open workbook dialog box appears.
Navigate to the location of the OfficeConnect for Excel workbook that contains the named ranges you want to link with.
Remember that OfficeConnect for Excel workbooks have a filename extension of xlsxai, while regular Excel workbooks have a filename extension of xlsx.
Double-click the file name.
If you select an OfficeConnect for Excel workbook that doesn’t have any named ranges defined, an alert appears and prompts you to open the source file and create the named ranges.
When you select an Excel workbook that contains named ranges, the workbook is successfully connected with the Word document. The name of the workbook and a list of its named ranges appears in the OfficeConnect links pane on the Workbook Links tab.
Note: You can link multiple Excel workbooks to a single Word file. Simply repeat steps. As you add connections, the name of the workbook appears on the Workbook Links tab of the OfficeConnect links pane in the order in which you add it. Under each workbook name are the tab names, table links, and single links.
Whenever you close and reopen an OfficeConnectt for Word file, any linked tables and data are intact as you saved them. However, if you want to work with the named ranges from the source file, you need to connect to the source files again by repeating steps. For more details, see Managing Links and Their Sources.