+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 10 of 15
  1. #1
    Junior Member
    Using
    AutoCAD LT 2010
    Join Date
    Jul 2009
    Posts
    14

    Question How to completely delete a table data link

    Registered forum members do not see this ad.

    Using AutoCAD 2010 LT with service pack 1 and 2

    I created a link to an Excel file to create a table. Before I ETransmit the AutoCAD file (along with many other files) I want to remove the link so that the table is embedded with no need for the external file. When I have somebody who doesn't have the linked file on their machine open the file they get a "missing external file" message" despite the fact that I ran the detach data link command and have purge selected in the ETransmit setup. The table shows up with the data, but I want to eliminate the nag pop up about the missing file. I know you can click the ignore button, but I don't want our customer to have to bother with it.

    By the way does anyone know a way to save a list of files for ETransmit like you do in a .dsd file for batch plotting?

  2. #2
    Senior Member Tommy78's Avatar
    Computer Details
    Tommy78's Computer Details
    Operating System:
    Win XP
    Using
    AutoCAD 2009
    Join Date
    Feb 2009
    Location
    Antwerp/Belgium
    Posts
    147

    Default

    to remove the datalink from your xref manager:
    1) rename or remove the linked .dxe files
    2) copy/paste this:
    Code:
    (dictremove (namedobjdict) "ACAD_DATALINK")
    in the commandline, ENTER
    3) save and close the drawing, reload drawing

    this works in 2009, don't know if it works in 2010
    Last edited by SLW210; 20th Jul 2012 at 05:00 pm.

  3. #3
    Forum Newbie
    Using
    Architecture 2010
    Join Date
    Aug 2010
    Posts
    1

    Default

    wow that is awsome. My only question is what exactly does it do? dictremove=? namedobjdict=? should there not be a way to do this with standard acad commands?

  4. #4
    Forum Newbie
    Using
    Electrical 2012
    Join Date
    Oct 2011
    Posts
    1

    Default Same Problem With ACAD Electrical 2012

    I am having the same problem as described above. I am using AutoCAD Electrical 2012. I need to completely delete a Data Link for an external Reference File. I tried the tip above in this thread, but my 2012 version says "Unknown Command" in the command line... it does not recogize this remedy from earlier versions...

    Can anyone help me delete this Data Link / Reference File?

  5. #5
    Super Member irneb's Avatar
    Computer Details
    irneb's Computer Details
    Operating System:
    Win7 Pro 64bit
    Computer:
    Antec One Hundred
    Motherboard:
    ASUS P8P67-Pro P67
    CPU:
    Intel i7 2600 @ 3.4GHz
    RAM:
    16GB-1600MHz
    Graphics:
    GeForce GT 430 (1GB)
    Primary Storage:
    Seagate1TB SATA2 - 7200rpm
    Monitor:
    Samsung 2333TN 23" 1920 x 1080 Full HD LCD Monitor2GW
    Discipline
    Architectural
    irneb's Discipline Details
    Occupation
    Architectural Technician and Programmer
    Discipline
    Architectural
    Using
    AutoCAD 2013
    Join Date
    Sep 2010
    Location
    Jo'burg SA
    Posts
    1,729

    Default

    Data links are stored inside the drawing file as dictionary objects. That line which Tommy gave is a lisp which deletes the entire link dictionary - i.e. removes all data links. Most links disappear of their own, or you can delete them through the DataLink command. Some don't want to play well though. If you want a more fine-grained control, you could try my DictEdit routine here: http://forums.augi.com/showthread.php?t=78139
    Knowledge is proportional to experience, but wisdom is inversely proportional to ego!
    My little bit of "wisdom": Hind-sight is useless, unless used to improve the next forethought!

  6. #6
    Forum Newbie
    Using
    Inventor 2011
    Join Date
    Jul 2012
    Posts
    3

    Default

    Quote Originally Posted by Tommy78 View Post
    to remove the datalink from your xref manager:
    1) rename or remove the linked .dxe files
    2) copy/paste this:
    Code:
    (dictremove (namedobjdict) "ACAD_DATALINK")
    in the commandline, ENTER
    3) save and close the drawing, reload drawing

    this works in 2009, don't know if it works in 2010
    The only problem with this is that Autocad LT cannot run lisp commands. I'm running the exact same version as the O.P. and having the same issues.

  7. #7
    Senior Member
    Discipline
    Manufacture
    eyde's Discipline Details
    Occupation
    Project Manager/ Regional CAD Manager
    Discipline
    Manufacture
    Details
    We manufacture concrete utility vaults
    Using
    AutoCAD 2011
    Join Date
    Sep 2010
    Location
    Southern California but a true Texan
    Posts
    104

    Default

    Just type in XREF and the dialog box will come up. Detach all of your data links in the dialog box. Now your good to go.

  8. #8
    Forum Newbie
    Using
    Inventor 2011
    Join Date
    Jul 2012
    Posts
    3

    Default

    The X-ref palate will not let you remove data links.

    And the problem we are having is the actual deletion. I've already detached every reference, but when i go to try to delete it, it gives the error stating it is still referenced somewhere.

  9. #9
    Senior Member
    Discipline
    Manufacture
    eyde's Discipline Details
    Occupation
    Project Manager/ Regional CAD Manager
    Discipline
    Manufacture
    Details
    We manufacture concrete utility vaults
    Using
    AutoCAD 2011
    Join Date
    Sep 2010
    Location
    Southern California but a true Texan
    Posts
    104

    Default

    I am sorry that did not work for you.

    I use tables all day long and I just detach the data link by selecting a cell right click and go to detach data link which makes my table just text.

    Then I go to the xref manager and select the data link right click select detach.

  10. #10
    Super Member irneb's Avatar
    Computer Details
    irneb's Computer Details
    Operating System:
    Win7 Pro 64bit
    Computer:
    Antec One Hundred
    Motherboard:
    ASUS P8P67-Pro P67
    CPU:
    Intel i7 2600 @ 3.4GHz
    RAM:
    16GB-1600MHz
    Graphics:
    GeForce GT 430 (1GB)
    Primary Storage:
    Seagate1TB SATA2 - 7200rpm
    Monitor:
    Samsung 2333TN 23" 1920 x 1080 Full HD LCD Monitor2GW
    Discipline
    Architectural
    irneb's Discipline Details
    Occupation
    Architectural Technician and Programmer
    Discipline
    Architectural
    Using
    AutoCAD 2013
    Join Date
    Sep 2010
    Location
    Jo'burg SA
    Posts
    1,729

    Default

    Registered forum members do not see this ad.

    If that doesn't work and you can't use lisp (i.e. on LT), then try doing a WBlock (with Entire Drawing checked). As long as there's no tables attached to a datalink, this should make a new duplicate DWG file without any datalinks in it. Just make sure you've detached all data links from all tables (as Eyde's explained) before doing the wblock.

    Note wblock does much more than detatch datalinks, it's one of the oldest methods for cleaning a DWG file. Usually it cleans it better than you can accomplish with purge & audit only. This is both good and bad, e.g. while all the usual stuff gets "purged", unexpected purges also happen like unused Page Setups are cleared.
    Knowledge is proportional to experience, but wisdom is inversely proportional to ego!
    My little bit of "wisdom": Hind-sight is useless, unless used to improve the next forethought!

Similar Threads

  1. adding data to polyline and extracting this data to table?
    By feargt in forum AutoLISP, Visual LISP & DCL
    Replies: 22
    Last Post: 24th May 2013, 08:04 pm
  2. Replies: 2
    Last Post: 19th Aug 2009, 02:40 pm
  3. Excel Table Data Link
    By johnv in forum AutoCAD General
    Replies: 17
    Last Post: 31st Jul 2009, 12:11 am
  4. How can I edit a Table Data Link Value via VBA or LISP?
    By PJF in forum AutoLISP, Visual LISP & DCL
    Replies: 5
    Last Post: 17th Feb 2009, 03:28 pm
  5. Edit Table with Data Link
    By Tconn in forum AutoCAD General
    Replies: 4
    Last Post: 25th Sep 2008, 02:20 pm

Bookmarks

Posting Permissions

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