Delete Multiple Datalinks from a Drawing

[Anonymous]

I have a drawing that has many Excel Links, but only one is being used.  How can I delete all but the one I need using the Data Link Manager is very slow and tedious.

[ennujozlagam]

@Anonymoushello, you can try to check this LINK maybe could help you then. thanks

[imadHabash]

Hi and Welcome to AutoCAD Forum,

>>  Data Link Manager is very slow and tedious. <<

you may need to Audit and Purge (Regapps) your drawing.if the excel data are still exist in your drawing erase the unwanted ones. NOW from DATALINK command and when the dialog appeared right click over the unwanted excel data links and delete them. 

hope that what you're asking for...

Regards,

[dseaton · Accepted solution]

WBLOCK the drawing entities into a new drawing. doesn't take the datalinks with it.

[john.vellek · Accepted solution]

Hi @Anonymous,

If you are having difficulties removing them using the Datalink manager, try using the attached lisp.  It utilizes the DCL file  that is included in my attached Zip file. To use this, put both files in your working support file search path.

[john.vellek]

Hi @Anonymous,

I am coming back to your thread to see if the issue or question you posed has been resolved.  If so, please mark the post or posts as Solution(s) to help others find the answer quickly. If your issue persists, please give me a bit more detail on this issue so we can continue to work towards getting this solved.

[ljames]

DataLinks solved my problem. Sometimes we forget the simplest solutions.

[gregjrome70148]

John Vellek, I like your program DictEdit and the DCL. It has it uses and works well. I am searching for a method to batch remove all unused datalinks from a directory of drawings. I believe this could be accomplished using one or more of the codes written in DictEdit by turning it into a script (scr) and running it though "Autoscript" I'm not really sure about the command that would execute this and before I waste anymore time experimenting, if you know the exact command to do this with, I sure would appreciate it. Also, it could be a code to remove all data links, because the ones existing don't usually delete if in use. Please let me know, I would apprectiate it. Thanks Greg Rome

[akshay_ladZTCJ]

Hello,

Same problem i am facing. I am able to delete data links but one by one. There are min 40 to 50 data links are creating in each file and i work on almost 150 files per day. I wanted to know is there any way to delete all data links in one go.

Please check attached photo.

[gregjrome70148]

To Akshay_ladZTCJ: The only solution that I had found on removing all data links was in the previous thread. I had found a site that someone back in 2010 said this had worked. Check it out at: https://www.cadtutor.net/forum/topic/17368-lisp-needed-for-removing-datalinks-from-the-xref-list/

[gregjrome70148]

Thank you John, sorry for the very long delay in response. I appreciate it.

[trichardsonWK8WN]

I downloaded this, unzipped, used the appload command, and the command line says : 

DictEdit.lsp successfully loaded.
Command:
Command:
Command: DICTEDIT
; error: quit / exit abort

[trichardsonWK8WN]

I downloaded this DictEdit.zip. I unzipped it, used the appload command and found it and added the lsp successfully. Then I ran it and the command line says this:

DictEdit.lsp successfully loaded.
Command:
Command:
Command: DICTEDIT
; error: quit / exit abort

[cadffm]

Hi,

and you followed Johns instructions?

>>"To use this, put both files in your working support file search path."

[trichardsonWK8WN]

Yes.

[cadffm]

Copy and paste this line will show the "Should work!" message, right?

(alert (if (findfile "DictEdit.dcl") "Should work!" "isn't found in you supportpaths"))

Sorry, in this case I don't know the answer.

[jonathan_watkins_09]

For all who were wondering, the DictEdit lsp does work great. The datalink thing has been a hassle for me for awhile. I will attach the file here for future use. It is basically an app, and you can add it by going to the manage tab, selecting load application, and then selecting the DictEdit.lsp file from wherever you have it saved. make sure you choose to run thi program every time you open AutoCAD