CAD tip # 6304:

Question CAD
% platform category

How to insert a live-updated XLS table in an AutoCAD drawing?

You can insert an Excel table, Word document or other OLE object (e.g. from MS Office) into your DWG drawings. Such object will keep the link to the original file and when the original is updated, it updates also the AutoCAD contents.

This function is available in all Windowes versions of AutoCAD. In higher AutoCAD versions, you can also use more advanced functions which link XLS tables directly to native AutoCAD entities.

Insert the OLE object using the INSERTOBJ command (Insert > OLE Object...). In the "Insert object" dialog, choose "From file" and pick your .XLS (.DOC, etc.) file. It is important to check the "Link" option and uncheck the "Display as icon" option. End the dialog by OK. Right-click on the inserted OLE object to move it, scale it and set its properties (scale, display quality, etc.).

Any subsequent changes in the .XLS file will immediately (after save) display also in AutoCAD.

ACADLTADT

* CAD

12.9.2008 16568×

Comments Tell a friend

Prices - CAD eShop:

AutoCAD

AutoCAD LT

AutoCAD Architecture

applies to: AutoCAD · AutoCAD LT · AutoCAD Architecture ·

See also:
Tip 13040:	iLogic - display information about complexity of an Inventor part.
Tip 12828:	How to quickly delete 3rd party links to external objects in Inventor?
Tip 12641:	How to copy a graph from Excel to AutoCAD?
Tip 12165:	Inventor stopped to prompt for unresolved references.
Tip 9363:	How to hide the frame of a wipeout, embedded DWF or DGN?

Selected tip: How many floating licenses are consumed by two AutoCAD sessions run on one PC?

Back All CAD Tips

How to lock all viewports in all layouts? « | » How to get XYZ coordinates of a point on an Inventor assembly?

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:
Use Google Earth images in your AutoCAD projects with the Plex.Earth Tools

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

	CAD Forum - tips, tricks, utilities, help, how-tos and FAQ for AutoCAD, LT, Inventor, Revit, Map, Civil 3D, Fusion 360, Forma, 3ds Max and other Autodesk software (support by Arkance Systems) - see About	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 © 2024 \| Advertise with us \| Online privacy

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