Understand Data Linking and Matching

Up a level to ..

Understand Data Linking and Matching

 

Share Data Between Drawings and Applications > Extract Data from Drawings and Spreadsheets > Link an Excel Spreadsheet to Access Data > 

Understand Data Linking and Matching

Expand All Expand all collapsed sections. Collapse All Collapse all expanded sections.

Concept

Procedure

Quick Reference

To set up a named range in Microsoft Excel to use in a data extraction

1. In Microsoft Excel, open the workbook or spreadsheet that you want to access.
2. Select a range of cells to function as a linked range.
3. Enter a name for the range of cells in the Name Box, then press ENTER.
4. Repeat steps 2 and 3, if desired, to specify additional linked ranges.
5. On the File menu (Microsoft Excel), click Save.