AutoCAD 2010/2011/2012

Reply
Member
jcid
Posts: 3
Registered: ‎10-22-2010
Message 1 of 7 (1,966 Views)

link cad tables to excel

1966 Views, 6 Replies
10-22-2010 02:00 PM

Hi everyone,

 

I have a drawing with 40 excel data link, all linked to one spreadsheet excel file. It's there anyway to change the excel file in all the data links at the same time without having to go to Tools -- Data Links -- Data Link Manager -- right click edit on each one to change the excel file? Any lisp routine or solution will be greatly appreciated.

 

Thanks!

Distinguished Mentor
wengle
Posts: 658
Registered: ‎06-02-2010
Message 2 of 7 (1,945 Views)

Re: link cad tables to excel

10-22-2010 06:07 PM in reply to: jcid

First you need to open your Excel worksheets that are linked to your autocad drawing. Then open the drawing with the table(s). Now, when you double pick the table, the Excel worksheet will pop up and you can make the change(s) that you want and they will be reflected in the drawing as well as in the worksheet. See the attached.

Member
jcid
Posts: 3
Registered: ‎10-22-2010
Message 3 of 7 (1,871 Views)

Re: link cad tables to excel

10-25-2010 07:33 AM in reply to: wengle

Thanks, but that's not exactly what I’m looking for.  When I go to:


 -Tools

 - Data Links

- Data Link Manager

 

Under --Excel Links—I have already created 40 different excel links with different content on them and from the same excel file.  So each one of the 40 excel link takes a different group of cells of the same excel file.  When I want to change the excel file that the 40 excel links are linked to, I have to go to:

 

-Tools

 - Data Links

- Data Link Manager

-Double click on ONE excel link

-under Choose and Excel File, change the excel file to the New created excel file.

-press ok.  And proceed to do the same steps with all 39 left excel links.

 

It’s almost like just opening the excel file from a CAD excel data link, doing a SAVE AS, changing the name and, as a miracle, having all Cad excel links adapt to the new name. (When I do a SAVE AS all 40 data links are still linked to the original, not to the new saved excel file)  

*Expert Elite*
pendean
Posts: 22,634
Registered: ‎11-06-2003
Message 4 of 7 (1,869 Views)

Re: link cad tables to excel

10-25-2010 07:36 AM in reply to: jcid

I believe the only painless way to do that is to buy a third party add-on similar to http://www.dotsoft.com/xl2cad.htm

Dean Saadallah Blog | Facebook | Google+ | Twitter | PINS
Active Contributor
Melnyk
Posts: 27
Registered: ‎10-17-2006
Message 5 of 7 (1,832 Views)

Re: link cad tables to excel

10-26-2010 04:48 AM in reply to: jcid

jcid

 

If I understand this correctly, you have 40 Data Links to a single Excel file.

You then create a new excel file (presumably with a new name).

You then have to update each Data Link individually to match the new filename.

 

I can understand why you think this is long winded!

Have you tried repathing the Data Link in Reference Manager?

 

Mike

Mentor
AlistairBean1906
Posts: 189
Registered: ‎09-09-2010
Message 6 of 7 (1,823 Views)

Re: link cad tables to excel

10-26-2010 06:08 AM in reply to: Melnyk

I am assuming that the XL files are very updates to a newer revision. if that is the case then I would look at your file naming convention. If you have revision numbers on the filenames (xx1.xls xx2.xls etc) then look at having a filename for the latest release only (xxcurrent.xls) then simply archive the previous release and rename the newest to this name prior to opening the drawing.

 

I find this a good practice with XRefs as well, rather than repathing several drawings to the latest version have a fixed location and name for the latest and replace it when required.

Member
jcid
Posts: 3
Registered: ‎10-22-2010
Message 7 of 7 (1,782 Views)

Re: link cad tables to excel

10-27-2010 08:37 AM in reply to: jcid

Hi everyone,

 

 Thanks for trying to help.

 

I took care of the problem by selecting "Relative Path" under "Path Type" in the Data link menu and just moving the drawing with the Excel file to separate folder. That way:

 

Good

-Templates can be all linked to one Excel file, and when making a New drawing using the templates I just have to copy the Excel file in the folder of the New drawing.

 

Bad

- Same Excel file name in all folders which makes things a little difficult to target one. But as long as they are in the same folder or subfolder as the New drawing, everything is good!

 

 I know maybe some of you did know about "Relative Path", it's hard to explain the whole problem on the Web.

 

Thank you!!

Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.