AutoCAD 2010/2011/2012

AutoCAD 2010/2011/2012

Posts: 19
Registered: ‎03-27-2012
Message 1 of 2 (103 Views)

Changing Part Descriptions using excel

103 Views, 1 Replies
03-30-2012 03:26 PM

I have a set of part descriptions that need to be changed. Each part description corresponds to a part number. See the example below of what it would look like in AutoCAD.


123     screw

265     bolt

847     washer


But this list can get really long. Each part number and each description is a seperate text string or mtext string.


I plan on having an excel spreadsheet that has a list of all part numbers that my company uses with their corresponding descriptions.


I would like to use the part number to find the appropriate description and then change the description.


Hopefully this can be done automatically for a list of part numbers and their descriptions.


Is there a way to do this?

Posts: 161
Registered: ‎06-16-2008
Message 2 of 2 (86 Views)

Re: Changing Part Descriptions using excel

04-02-2012 12:46 AM in reply to: nothin

i might have picked up the wrong end of the stick, but have you looked at the datalink manager (Tools -> Data Links -> Data Link Manager...)


You can link the excel sheet to the drawing, similar to an xref, so when the excel file changes, you will get a notification bubble down the bottom right

Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.