CAD tip # 9665:

Question CAD
% platform category

Automatic update of tables linked with datalinks.

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

* CAD

27.1.2014 9359×

Comments Tell a friend

Prices - CAD eShop:

applies to: AutoCAD · AutoCAD Architecture · AutoCAD Mechanical · Civil 3D · AutoCAD Map 3D · AutoCAD Plant 3D ·

See also:
Tip 11990:	How to open a local .F3Z file in Fusion 360?
Tip 11898:	Automatic schedule - number of blocks in a drawing.
Tip 11896:	How to drive dyn.block parameters or constraints from Excel?
Tip 11539:	How to import Solid Edge parts and assemblies into Autodesk Inventor?
Tip 11053:	Can I use the default parameter URL to reference a relative link?

Selected tip: How to draw barcode in AutoCAD drawings?

Back All CAD Tips

Color fills missing in Inventor renderings. « | » Where to find the Portable license utility (PLU) in AutoCAD 2010, 2012, 2014 and higher?

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: OS: Categ:
Text:	FAQ glossary

Featuring:
Track your time spent working on AutoCAD or Revit jobs - automatically with
CADstudio JobTime More info

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

CZ \| EN \| DE
Login or
registration
	Visitors: 3197

	CAD Forum - tips, tricks, utilities, help, how-tos and FAQ for AutoCAD, LT, Inventor, Revit, Map, Civil 3D, Fusion 360, 3ds max and other Autodesk software (support by Arkance Systems)	Arkance Systems CZ s.r.o. (CAD Studio) - Autodesk Platinum Partner & Training Center & Consulting Services Partner	CONTACT: webmaster.cz@arkance-systems.com tel. +420 910 970 111
	Copyright © 2021 \| Advertise with us \| Online privacy