CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products [www.cadforum.cz]
Cesky English Deutsch
Login/Register:
 Visitors: 2712 

CAD tip CAD tip # 4391:

Question CAD 
 %  platform  category 
Q - question

Pasting intelligent tables from Excel to AutoCAD.

A - answer 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.

ACAD2006LT2006ADT2006Map2006
100% *  CAD 
3.5.2005    31090×  
Comments   Tell a friend

See also:
Tip 11665:Export to Excel creates an empty table with the text DeleteMe.
Tip 11581:How to compare changes between two versions of a Revit BIM project?
Tip 10799:Exporting tables from AutoCAD Civil 3D to Excel.
Tip 10231:How to draw spiral in AutoCAD LT?
Tip 9930:Editing history of Revit RVT files.


Back   All CAD Tips All CAD tips&tricks

Quiet installation of 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: CAD Forum - tips, utilities, blocks for Autodesk products
CAD:    OS:    Categ: 
Text:  FAQ glossary   



Featuring:
Add .CIT raster format support to AutoCAD and Map and Civil 3D
CITin More info


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