Likewise, if a change is made to the table in the drawing, the linked spreadsheet can be updated using the same command.ĭata linking is the process of selecting a Microsoft Excel spreadsheet with the purpose of merging all or some of its contents with extracted drawing data. If a linked spreadsheet has been changed, such as a row or column has been added, the table in your drawing can be updated accordingly using the DATALINKUPDATE command. If Microsoft Excel is not installed, or if the XLS file is not saved locally on the computer that is performing the data extraction, a data link cannot be established. On the Refine Data page, you access the Link External Data dialog box you can set up a link to an entire Excel spreadsheet, or to a range of rows and columns, to the extracted data.īefore you can link a spreadsheet, Microsoft Excel needs to be installed on the same computer on which the data extraction is performed. Select the columns in the XLS file to merge with the extracted drawing data.Match the extracted drawing data and the spreadsheet data.Specify a data link by selecting an XLS file to which the extracted data from the drawing will be linked.Using the Link External Data dialog box, you can: By linking to an Excel spreadsheet, you can include information from an entire worksheet, or part of a worksheet, referred to as a
