CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products [www.cadforum.cz] ARKANCE | CONTACT - CZ | SK | EN | DE
Over 1.096.000 registered users (EN+CZ). AutoCAD tips, Inventor tips, Revit tips. Try the new precise Engineering calculator and the updated Barcode generator. New AutoCAD 2026 commands and variables.

CAD tip CAD tip # 9665:

Question

CAD 
 %  platform  category 
A
Using the commands TABLE resp. DATALINK you can insert a live content of Excel tables (or parts of them) to your AutoCAD drawing. On any subsequent change of the Excel table you will be notified by AutoCAD and you will have to update the DWG content manually (updates do not depend on the DXEVAL variable).

If you want to perform the update of Excel table data automatically, after you open your DWG drawing, you can use a simple LISP function. Find the file ACADDOC.LSP (by default in the local user Support folder) and add the following line using Notepad.exe:

(command "_DATALINKUPDATE" "_U" "_K")

If the file ACADDOC.LSP does not exist, create it.

Now after you open any drawing, its data links will be automatically updated.

ACADADTACADMCivilMapPlant
100% *CAD
27.1.2014    15854×  

See also:
Tip 14620:Converting object data (OD) to XData (XD) in AutoCAD Map 3D.
Tip 14604:QRcode - dynamically generated QR codes in AutoCAD.
Tip 14584:How to connect external resources (IoT) to the BIM model in Autodesk Tandem?
Tip 14560:JobTime for Autodesk Fusion - tracking time spent on a job.
Tip 14555:How to disable or expire a public link to my Fusion design?


Back    All CAD Tips



Have we helped you? If you want to support the CAD Forum web service, consider buying one of our CAD applications, or our custom software development offerings, or donating via PayPal (see above). You may also add a link to your web - like this "fan" link: CAD Forum - tips, utilities, blocks for Autodesk products
CAD: 
OS: 
Categ: 
Text:
 FAQ
  



Featuring:
Publish interactive 3D PDF models from AutoCAD, Inventor or Revit with Share3D More info


Please use these tips at your own risk.
ARKANCE is not responsible for possible problems that may occur as a result of using any of these tips.
TOPlist