Tip : Link Excel to AutoCAD Table

Method : 1 (Link Excel to an empty table) 

• Open Excel file and check start and end cell number which you wish to Link
• In AutoCAD type command  “TABLE” or from drop down menu “Draw -> Table”
• “Insert Table” window will pop up
• Select Insert option “Start from empty table”
• Pick a point on your screen to insert table
• Now click on the first cell of the table ribbon bar and click “DATA” button, then select “Link cell”
• From “Select a Data Link” window, click on “Create a new Excel Data Link”  
• Enter a new name
• Then browse the excel file
• If you don’t want to Link the entire sheet then click on “Link to Range”
• Enter Start and end of the excel cell number (eg.  A1:B9)
• Click “OK” 

Method : 2 (Insert table from a Data Link) 

• Insert “TABLE”
• Select Insert option “From data Link”
• Then browse the excel file
• If you don’t want to Link the entire sheet ,then click on “Link to Range”
• Enter Start and end of the excel cell number (eg.  A1:B9)
• Click “OK” 

Method : 3 (Paste Special Paste Link) 

• Open Excel file and select cells ,copy to clip board
• Switch to AutoCAD, from “EDIT” drop down menu Select “PASTE SPECIAL”
• Click on “PASTE LINK” and select “AUTOCAD ENTITIES”
• Pick a point on your screen to insert table. 

Note : If you are not able to see the text ,Select table check properties (Cntr+1) , select cells and adjust the text height, cell width and cell height.

Update Link from Excel

Method : 1 (Update by icon) 

• Click on any cell on table
• From the table window click icon “Download from source” 

Method : 2 (Update by Right Click) 

• Select table then “Right Click”
• And select “ Update table Data Links” 

Or 

• Select any Cell then “Right Click”
• Click on “Data Links”
• From the  sub menu  you can choose
• “Download Changes form Source File” It will Update the Table contents according to Excel file.
• “Upload User Changes to Source File”  Can Edit table contents and Update your Excel file from autocad
• “Edit data Links”  Can edit Cell range (eg. A1:H17 to A1:K20 )
• “Open Data Link File..” Can Open Linked Excel File form Autocad.
• “Detach Data Link”   Can detach the table from the Link.  

Related post : Export Autocad Table to Excel