Want your Excel spreadsheet within your AutoCAD drawing!?

[matthew.d]

Many of you may be curious about linking your Microsoft Excel spreadsheets to a table within your drawing. This is possible in AutoCAD through Data Link.

How to create a data link:

1. Click the “Annotate Tab” on the Ribbon
2. On the “Tables” panel,  click the DATALINK icon
         a.     Alternatively, type DATALINK into the “Command Line” and press Enter

3. Within the Data Link Manager, click “Create a new Excel Data Link”

4. Enter the name of the data link within the “Enter Data Link Name” dialog box and press OK

5. Click the button next to “Browse for a file …” and navigate to the location of the Excel file to be inserted into the drawing

6. Click OK to close the Data Link dialog boxes

7. In the Tables panel on the Annotate Tab, click the “Table” icon

         a.     Alternatively, type TABLE into the “Command Line” and press Enter

8. In the “Insert Table” dialog box, check “From a data link” under the “Insert options” header.  Then from the pull down menu, select the linked table and click OK

9. Select the insertion point for the data link table

You can find out more information, such as: keeping data formats, solve formulas, about data links here.

Also, don't forget about the DATALINKUPDATE command, to update any change formatting.

If you need any additional help, please visit us on Twitter @Autodeskhelp or if you have any other product specific questions please post a new message in one our Autodesk Community forums.

[jermaine2005]

Thank you very much for this tip! amazing!