AutoCAD TABLE vs Linked Table
AutoCAD has two types of tables: native tables (created entirely within AutoCAD) and linked tables (connected to an external Excel file via a Data Link). Understanding the difference is critical for choosing the right approach.
| Feature | Native TABLE | Linked TABLE (Excel) |
|---|---|---|
| Data source | Typed directly in AutoCAD | External .xlsx / .csv file |
| Auto-update | No — manual edits only | Yes — via DATALINKUPDATE |
| Formula support | Basic (SUM, AVERAGE in cells) | Full Excel formulas (before linking) |
| Multi-user editing | One person at a time in DWG | Excel can be edited while DWG is open |
| Best use | Static schedules, note blocks | Live equipment schedules, BOMs, pole loading |
| Portability | Self-contained in .dwg | Requires .xlsx in same relative path |
| Column width control | Full in AutoCAD | Inherited from Excel, adjustable in AutoCAD |
| Plotting reliability | Always plots as-is | Must update before plotting |
💡 Utility drafters: Use linked tables for pole schedules and equipment lists that engineers update in Excel. Use native tables for static note blocks and sheet indexes that only change in AutoCAD.
FIELD Codes — Auto-Updating Text
FIELD codes are special text objects that automatically pull data from the drawing, file system, or sheet set. They update when you plot, save, or run UPDATEFIELD. Perfect for title blocks, revision clouds, and schedule dates.
| Field Type | Command | Common Use | Updates On |
|---|---|---|---|
| Date (current) | %<\AcVar Date>% | Issue date in title block | Every plot / UPDATEFIELD |
| Save Date | %<\AcVar SaveDate>% | "Last revised" in title block | Every save |
| Plot Date | %<\AcVar PlotDate>% | Print date stamp | Every plot |
| File Name | %<\AcVar Filename>% | Drawing number in title block | Every open / UPDATEFIELD |
| Author (doc prop) | %<\AcVar Author>% | Drawn By field | UPDATEFIELD |
| Sheet Number (SSM) | %<\AcSsField SheetNumber>% | Sheet X of Y numbering | Sheet set update |
| Sheet Total (SSM) | %<\AcSsField TotalSheets>% | Total page count | Sheet set update |
| Object property | Insert → Field → Object | Pull length/area from geometry | Object changes |
⚠️ FIELD codes display with a gray background in the drawing editor — this is normal and won't plot. Run
UPDATEFIELD before plotting to ensure values are current. Use FIELDEVAL = 31 to auto-update on all triggers.TABLESTYLE — Key Commands
TABLE
Insert a new table (native or linked)
TABLESTYLE
Create / edit / set current table style
DATALINK
Manage data link connections to Excel/CSV
DATALINKUPDATE
Push/pull data between Excel and AutoCAD table
FIELD
Insert a FIELD code into text or table cell
UPDATEFIELD
Force update all FIELD codes in drawing
FIELDEVAL
Set which events trigger auto field update (0–31)
TABLEDIT
Edit table cell content in-place
TABLEEXPORT
Export AutoCAD table to .csv file
EXTRACTDATA
Extract object attributes/properties to table or file
EATTEXT
Extract block attribute data to Excel/table
DATAEXTRACTION
Wizard-based data extraction from blocks/objects
EXTRACTDATA / EATTEXT — Live Block Schedules
One of the most powerful AutoCAD data features: extract attribute data from all blocks in a drawing into an auto-updating table. For utility work, this means your pole schedule can auto-populate from the pole block attributes you placed in the drawing.
What Gets Extracted
- Block name
- All attribute values (ATTDEF fields)
- Insertion point (X, Y, Z coordinates)
- Layer name
- Block count / quantity
- Object properties (color, lineweight)
- Custom properties
Utility Drawing Applications
- Pole schedule from pole blocks (height, class, guying)
- Equipment schedule from transformer blocks
- Bill of materials from device blocks
- Span table from conductor annotation blocks
- Guy wire schedule from guy block attributes
- Streetlight schedule from light fixture blocks
System Variables
FIELDEVAL
0=never, 1=new, 2=save, 4=plot, 8=etransmit, 16=regen
Controls when FIELD codes automatically update. Set to 31 (all triggers) in templates.
TABLEINDICATOR
0=off, 1=on
Shows row/column indicators when editing a table. Set to 1 for easier editing.
FIELDDISPLAY
0=no highlight, 1=gray highlight
Controls the gray background on FIELD codes. Set to 0 before plotting screenshots.
DTEXTED
0=in-place editor, 1=dialog box, 2=command line
Controls how DTEXT edits appear. Set to 0 for in-place editing (most efficient).
TEXTALLCAPS
0=off, 1=all caps
Forces all new MTEXT to uppercase. Useful for drawing standards requiring uppercase notes.
TABLESELECTED
Read-only
Returns the name of the current table style. Use TABLESTYLE to change the current style.
Common Problems
| Problem | Cause | Fix |
|---|---|---|
| Data link won't update | Excel file path changed or file is open by another user | Check DATALINK manager — verify path. Close Excel, then DATALINKUPDATE. |
| Table cells show "####" | Column too narrow to display value | Drag the column separator wider, or right-click → Column Width → set a larger value. |
| FIELD shows old value after save | FIELDEVAL set too low | Set FIELDEVAL = 31. Run UPDATEFIELD manually to force a refresh. |
| Linked table loses formatting after update | Excel cell merges or new rows inserted | Avoid merged cells in Excel. If rows added, re-check the data range in DATALINK. |
| EXTRACTDATA creates duplicate rows | Blocks on multiple layers or in blocks within blocks | Filter by block name in the extraction wizard. Check "Select objects" instead of "Entire drawing." |
| Table style not applying to new tables | Wrong style set as current | TABLESTYLE → select your style → Set Current, then re-insert table. |
| FIELD code shows formula text instead of value | FIELD not recognized (wrong syntax) | Delete and re-insert via Insert → Field dialog instead of typing manually. |
| Table explodes when client opens the DWG | Client using older AutoCAD version | Use TABLEEXPORT to send a CSV alongside the DWG. Linked tables require matching AutoCAD version. |