Results 1 to 3 of 3

Thread: update link excel & table in acad2009

  1. #1
    Member
    Join Date
    2001-11
    Location
    Malta europe
    Posts
    7
    Login to Give a bone
    0

    Unhappy update link excel & table in acad2009

    I have created a series of blocks with attributes & fields and have used data extraction to create table in drawing as well as creating an external excel list.
    I have not grasped the way the excel list updates when changes are made to the table.
    In excel I have create other columns with formulas which give me the desired output I need when changes are done.
    acad2009 has facilities that help to upload or download data between table and excel.

    where is the LINK!!! I must be doing some thing wrong.

  2. #2
    Certified AUGI Addict jaberwok's Avatar
    Join Date
    2000-12
    Location
    0,0,0 The Origin
    Posts
    8,570
    Login to Give a bone
    0

    Default Re: update link excel & table in acad2009

    Quote Originally Posted by zardeg View Post
    I have created a series of blocks with attributes & fields and have used data extraction to create table in drawing as well as creating an external excel list.
    I have not grasped the way the excel list updates when changes are made to the table.
    In excel I have create other columns with formulas which give me the desired output I need when changes are done.
    acad2009 has facilities that help to upload or download data between table and excel.

    where is the LINK!!! I must be doing some thing wrong.
    DATALINK command ?
    (don't know when it was introduced)

  3. #3
    Active Member
    Join Date
    2008-07
    Location
    Washington DC
    Posts
    82
    Login to Give a bone
    0

    Default Re: update link excel & table in acad2009

    I believe it was introduced in 08.

    It's basically a two step process. The first step is creating the data link, the second step is telling AutoCAD where you want that data link information to go. Similar to attaching an external reference .dwg, you first have to attach it, then you can place it, rotate it, and scale it.

    Attaching the spreadsheet is done with the DATALINK command. If you're familiar with excel then it should be a fairly painless process.

    Getting that datalink information into the drawings requires a TABLE where you can right-click and select "Data Link >" where it will give you the options to attach a datalink to the table, update the datalink, etc. When you actually insert the datalink in this step you get the options to retain both the formatting and the information, allowing the table to be updated automatically from the excel file (and vice versa). You can change these options later by right-clicking the datalinked area in the table.

Similar Threads

  1. 2014: Autocad table from Excel Data Link
    By sovby254640 in forum AutoCAD General
    Replies: 4
    Last Post: 2014-08-07, 11:19 PM
  2. Link Sheet set to Sheet List Table and Excel
    By autocad.wishlist1734 in forum AutoCAD Wish List
    Replies: 1
    Last Post: 2013-05-19, 05:52 AM
  3. inserting excel via data link into table
    By rjairath in forum AutoCAD General
    Replies: 2
    Last Post: 2007-12-19, 05:47 PM
  4. Replies: 1
    Last Post: 2006-12-12, 07:36 AM
  5. Replies: 3
    Last Post: 2006-11-30, 05:30 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •