Is there a way to link Excel cells to a Linear Dimension in cad?

Is there a way to link Excel cells to a Linear Dimension in cad? I use Excel as a Bill of Material and fill in material to it can calc. weights and track material. It would be nice if I could link a cell to a linear Dim so if the length changes in a DWG it will update in Excel?

I don't know but you may be able to datalink your excel sheet into the drawing. In the resultant table you may be able to insert a field and link that to the selected dimension. Using a datalink a change in dimension should trigger an out of sync event and allow you to write the table contents back to the spreadsheet.

I don't have AutoCAD here so I'll let you experiment.

Thanx Ill try it out..

The old autocad excell demo called "shaft" used a dynamic link if you changed autocad the excel changed likewise change excell and the drawing changed including redrawing it to new lengths!

thanx Bigal I thought there was an old Excel file that did that. Any idea where I can find that Demo?

I tried R14 could not find it maybe its called something else now I will have a look at home migth have a R12 version