Find The Named Range in Microsoft Excel
When you're working with a linked table in DM Word, you can open the Microsoft Excel linking document by right clicking it, then selecting Open CrossLinks.
Instead of searching through the sheets in your Excel workbook, you can quickly locate and navigate to the named range using these steps:
- Click the table in the DM Word report, then right click and select Manage CrossLinks
- Note the Named Range in the Named Range column
- If you have not already opened the Excel linking document, open it by clicking the hyperlink in the Source File column
- In Excel, click the Name Box drop down arrow, then scroll to find and select the named range
- The Excel workbook opens to the correct sheet and highlights the named range
Copyright © 2021 Certent