AutoCAD 2007/2008/2009

Reply
Valued Contributor
daryl_santos_201
Posts: 100
Registered: ‎07-23-2009
Message 1 of 18 (2,720 Views)

Field Excel Data Links

2720 Views, 17 Replies
11-11-2009 09:48 AM
I have set up a table where an a column "Area Total (SF)" is linked into the drawing as a field. The table is also linked to an excel file which includes formulas that need to use the field data. How do I have the table write to the excel file with the updated field and read the cells which use the formulas in the excel file?

Thanks Edited by: daryl_santos_201 on Nov 11, 2009 6:02 PM
Mentor
BernardMadoff
Posts: 578
Registered: ‎07-15-2009
Message 2 of 18 (2,719 Views)

Re: Field Excel Data Links

11-11-2009 11:33 PM in reply to: daryl_santos_201
you can't.......there has been a bug with the write data links to external source command......which has been there since at least 2008 and is still there in 2010.

when you right click on your updated table in your DWG and right click you should be able to select write data links to external source and this should write the new values out to your existing excel file, but the chances are you will get this error message

Command:
1 object(s) found.
1 data link(s) do not allow their data to be written out.
0 data link(s) written out successfully.
Valued Contributor
zlotinas
Posts: 51
Registered: ‎11-17-2008
Message 3 of 18 (2,606 Views)

Re: Field Excel Data Links

01-10-2011 11:57 PM in reply to: BernardMadoff

Autodesk Support says "check Allow writing to source file"

 

But it never helps, this feature is active by default in data linking dialog window.

 

So according to  BernardMadoff  "there has been a bug with the write data links to external source command......which has been there since at least 2008 and is still there in 2010"

 

-  and is still there in 2011:

 

 

Command: _DATALINKUPDATE
Select an option [Update data link/Write data link] <Update data link>: _W
Select objects: 1 found
1 data link(s) do not allow their data to be written out.
0 data link(s) written out successfully.

 


Valued Contributor
zlotinas
Posts: 51
Registered: ‎11-17-2008
Message 4 of 18 (2,356 Views)

Re: Field Excel Data Links

08-05-2011 12:33 AM in reply to: zlotinas

Finally, in 2012 version I've succeeded to "upload to the source" (kinda quote from the matrix :].

 

I guess it has something to do with newer MS office version of 2007, although I've never found any restrictions considering data linking with MS 2003.

 

One problem remains data link editing is still not active with right clicking the table:

 

table-data link.jpg

 

 

 so you have to open all data links, right click the one you need and check allow writing to source in expanded settings window.:

 

table-alllow-writing-2-source.jpg

 

 

For thouse who's new to the topic - http://youtu.be/I_r8LuX1IhY

 

New Member
forum.ric
Posts: 1
Registered: ‎12-22-2011
Message 5 of 18 (2,241 Views)

Re: Field Excel Data Links

12-22-2011 12:45 PM in reply to: zlotinas

I am trying to "Write data links to external source" on AutoCAD LT 2011 to Excel 2010 and still receive the following error.

 

1 object(s) found.
1 data link(s) could not be written out.
0 data link(s) written out successfully.

 

The ability to update the linked excel file after changes made in AutoCAD will definitely make my life so much easier at work!  Somebody please help!!

 

Contributor
wayne.deegan
Posts: 11
Registered: ‎07-12-2012
Message 6 of 18 (1,920 Views)

Re: Field Excel Data Links

10-12-2012 06:10 AM in reply to: forum.ric

I am using Autocad 2013 and still having this problem, I have to edit Data Extraction Settings and run through the few screens and export to file again in order to update the excel file. data.jpg

Valued Contributor
zlotinas
Posts: 51
Registered: ‎11-17-2008
Message 7 of 18 (1,915 Views)

Re: Field Excel Data Links

10-12-2012 06:39 AM in reply to: wayne.deegan

Try NanoCAD (DWG native, and english also available). It has build in sheet editor and update of tables in real time without any linking, updating, referencing ... endiing up with auto'glitches.

New Member
Lon.Lyford
Posts: 1
Registered: ‎02-12-2013
Message 8 of 18 (1,602 Views)

Re: Field Excel Data Links

03-09-2013 03:52 AM in reply to: daryl_santos_201

Greetings all, seems like this this thread has been dead for a bit. But I'm just getting into linking excell tables (2007) to Autocad (2012 Civil 3D) using data links. I've tried a couple different methods both using paste special and setting up a data link and then inserting a table associated with the data link. Does anyone know if the mentioned "bug" regarding exporting data to the linked excell file has been corrected yet and if it potentially has anythign to do with excell? I don't have any issues updating the data from excell to AutoCAD, but I'm getting mixed results going the other way. I can sometimes get it to export the data from AutoCAD to the excell spreadsheet, but it creats a new .XLSX file in "my documents" instead of updating the original excell file at the correct file location. Is there something I'm doing wrong?

 

Assuming this tool works and I'm just setting it up wrong, question #2. Is there a way to set the default for the datalink to have "allow writing to source file" checked when using the "paste special" method? This is a much faster way to get the link into excell, but currently it comes accross with that checkbox un checked.

 

Thanks for your time.

Valued Contributor
zlotinas
Posts: 51
Registered: ‎11-17-2008
Message 9 of 18 (1,596 Views)

Re: Field Excel Data Links

03-09-2013 05:30 AM in reply to: Lon.Lyford

 Thread is dead, problem is alive. And nothing has changed since the first post. I could solve the back and forth interation only once, between MS2010 and AutoCAD 2012. But on the other machine same things with same settings didn't work. Now it doesn't work with 2013.

 

Try reading once again this http://docs.autodesk.com/ACD/2011/ENU/filesACR/WS1a9193826455f5ffa23ce210c875431154bf0.htm

maybe you'll find out something between the lines... share if you do... :smileyhappy:

Active Member
nathan
Posts: 6
Registered: ‎08-07-2008
Message 10 of 18 (1,352 Views)

Re: Field Excel Data Links

06-03-2013 05:20 PM in reply to: daryl_santos_201

Whats the story with this? anything happening? using 2013 and still cant Write Data to External Source a sheetlist table containing fields.

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Are You Going To Be @ AU 2014? Feel free to drop by our AU topic post and share your plans, plug a class that you're teaching, or simply check out who else from the community might be in attendance. Ohh and don't forgot to stop by the Autodesk Help | Learn | Collaborate booths in the Exhibit Hall and meet our community team if you get a chance!