CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products []
CZ | EN | DE
Login or
  Visitors: 5439

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.

100% *  CAD 
3.5.2005    34128×  
Prices - CAD eShop:

See also:
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?
Tip 13757:Bulk editing of drawing properties (DWGprops) from Excel.
Tip 13531:Thumbnails have incorrect size after exporting the BOM to Excel.
Tip 13522:LookupXLS - populating DWG texts from Excel spreadsheets.

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 glossary   

Extend your AutoCAD LT productivity with our popular add-on
CADstudio LT Extension More info

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.