CAD tip # 4391:

Question

CAD

% platform category

Pasting intelligent tables from Excel to AutoCAD.

Did you know you can paste an Excel table to AutoCAD keeping the "live" cell formulas?

Even if your Excel table contains formulas like SUM, AVERAGE, COUNT or other expressions referencing other cells, you can Copy such table (cell range) from Excel and Paste it in AutoCAD 2006, LT 2006 or higher CAD applications. AutoCAD will retain these formulas and keep the 'intelligence' of the table in your AutoCAD drawing (a cell change will result in a computed change of all dependent cells in the AutoCAD table).

To transfer the table in this smart way use Paste Special and select AutoCAD Entities.

ACAD2006ACLT2006ADT2006Map2006

*CAD

3.5.2005 35339×

Comments Tell a friend

this tip shared by ARKANCE experts applies to: AutoCAD 2006 · AutoCAD LT 2006 · AutoCAD Architecture 2006 · AutoCAD Map 3D 2006 ·

See also:
Tip 14681:	How to quickly convert XLS tables to CSV format without opening Excel?
Tip 14361:	Extended ATTOUT/ATTIN for block attribute management in Excel (also for LT).
Tip 14218:	Does Inventor support Sensitivity Labels in MS Excel tables?
Tip 13855:	DBXscanLayers and DBXscanBlocks - bulk report content of DWG files in a folder.
Tip 13784:	Export block coordinates to a table. How to use the DATAEXTRACTION command in AutoCAD LT?

Selected tip: MDT can not find Excel 2000 Deutsch (German)version.

Back All CAD Tips

Quiet installation of Arkance Systems (XANADU, CAD Studio) applications. « | » Edit block attributes in multiple layouts.

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:

Text:

FAQ

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.

CADforum

Tips, tricks, utilities, help, how-tos and FAQ for AutoCAD, LT, Inventor, Revit, Map, Civil 3D, Fusion, Forma, 3ds Max and other Autodesk software (community support by ARKANCE). See About CADforum.

ARKANCE CZ - Autodesk Platinum Partner & Training Center & Consulting Services Partner

CONTACT:
webmaster.cz@arkance.world | tel. +420 910 970 111



Visitors now: 10458