Hello @john.vellek,
I followed the instructions listed below:
To create a Data Link I’ve found the easiest way is to simply just start creating a table using the Table button on the Annotate tab of the Ribbon. Selecting this button opens the Insert Table dialog box we need to first tick the From a Data Link radio button and then click the Launch Data Link Manager button as shown in the red box on fig. 2 below.
Fig. 2
At the Data Link Manager dialog box we will place a click on the text that says ‘Create a new Excel Data Link’, we are then prompted to enter a name for this link and select OK. Having done this we will be provided with the New Excel Data Link: <NAME> dialog box where we need to select the file we would like to link to using the three dot button as highlighted in the red box on fig. 3 below.
Fig. 3
Selecting your Excel file will expand the dialog box to that shown in fig. 3 above giving access to the Link options panel. Here you can choose wether to link to an entire Sheet, named range or a specified range of cells. Choosing OK will generate an entry for the newly created data link in the Select a Data Link dialog box where we will select it and choose OK. We will be returned to the Insert Table dialog box where we will select OK and then specify a location in the drawing for the table to be inserted. We are now able to use familiar AutoCAD processes to control the display options for the table. If the Excel data is updated while you are in the drawing you will be provided with a balloon notification in the lower right hand corner of the application as seen in fig. 4 below.
