Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Is there any way to link data from Excel to AutoCAD Table? It should work both ways.

user-image
Question added by Abdul Kareem Chala Mohammed , Senior Designer , iSmarthome
Date Posted: 2016/04/07
Elke Woofter
by Elke Woofter , Project Assistant , American Technical Associates

Yes it can be done ... I found this on AutoDesk.com

A table can be linked to data in a Microsoft Excel (XLSXLSX, or CSV) file. You can link to an entire spreadsheet, individual row, column, cell, or cell range in Excel.

Note:

Microsoft Excel must be installed to use Microsoft Excel data links. To link to the XLSX filetype, Microsoft Excel 2007 must be installed.

You can bring data from Microsoft Excel into a table in the following three ways:

  • As formulas with supported data formats attached.
  • As calculated data from formulas calculated in Excel (supported data formats not attached).
  • As calculated data from formulas calculated in Excel (with data formats attached).

A table that contains data links displays indicators around linked cells. If you hover your cursor over the data link, information about the data link is displayed.

If a linked spreadsheet has been changed, such as adding a row or column, the table in your drawing can be updated accordingly using the DATALINKUPDATE command. Likewise, if a change is made to a table in your drawing, then you can update the linked spreadsheet using the same command.

By default, a data link is locked from editing to prevent undesired changes to the linked spreadsheet. You can lock cells from data changes, format changes, or both. To unlock a data link, click Locking on the Table ribbon contextual tab.

Related Concepts

Related Tasks

Related Reference

 

 

Mohamed Sharaf Sharaf
by Mohamed Sharaf Sharaf , construction site manager , MAJAL ALENJAZ CONTRACTING CO.

Agree with Mr. Vaqar Ali Sayyed answer

thanks for the invite

Amr Gamal Anwar Hassan
by Amr Gamal Anwar Hassan , مهندس حاسب كميات , Shurfah Real Estate Development and Investment

I agree with Mrs. Elke Woofter

Vaqar Ali Sayyed
by Vaqar Ali Sayyed , AutoCad Opertator , Carlo Gavaazzi Arabia Co. Ltd.

By linking to an Excel spreadsheet, you can include information from an entire worksheet, or part of a worksheet, referred to as a named range. Using the Link External Data dialog box, you can:

Abu Bakar Ashfaq
by Abu Bakar Ashfaq , Senior Consultant , PricewaterhouseCoopers Middle East

No idea, but Alke answer seems to be good one.

Mushreq Abdulmajeed
by Mushreq Abdulmajeed , Senior Project Supervisor , Lagoon Spring Company

I agree with the answer of Mrs.Alke

Ahmed Mohamed Ayesh Sarkhi
by Ahmed Mohamed Ayesh Sarkhi , Shared Services Supervisor , Saudi Musheera Co. Ltd.

i didn't have experience on AUTOCAD sorry

 

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.