See the top rated post in this thread. Click here

Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 24

Thread: Excel Table to AutoCAD Table.

  1. #11
    All AUGI, all the time Capt. Computer Crasher's Avatar
    Join Date
    2006-12
    Location
    South of North & East of West
    Posts
    786
    Login to Give a bone
    0

    Default Re: Excel Table to AutoCAD Table.

    Quote Originally Posted by Lorraine.McNulty View Post
    CIVIL 3D 2008.......All service packs are automatically installed by IT
    sorry I was editing my last post. are you using copy/paste or the data-link option from the Table command. if using the table command data-link option instead of copy/paste

  2. #12
    Member
    Join Date
    2009-04
    Posts
    7
    Login to Give a bone
    0

    Default Re: Excel Table to AutoCAD Table.

    datalink option

  3. #13
    All AUGI, all the time Capt. Computer Crasher's Avatar
    Join Date
    2006-12
    Location
    South of North & East of West
    Posts
    786
    Login to Give a bone
    0

    Default Re: Excel Table to AutoCAD Table.

    Quote Originally Posted by Lorraine.McNulty View Post
    datalink option
    datalink from the TABLE COMMAND not the data link from copy /paste

  4. #14
    Member
    Join Date
    2009-04
    Posts
    7
    Login to Give a bone
    0

    Default Re: Excel Table to AutoCAD Table.

    yes that is correct. i had no problems with the first 15 tables. I even tried combining some tables to be only 12, but "table / insert from datalink / create new datalink" still locks me up every time........short of upgrading to 2009 or 2010 (not gonna happen) what do i do?

  5. #15
    All AUGI, all the time Capt. Computer Crasher's Avatar
    Join Date
    2006-12
    Location
    South of North & East of West
    Posts
    786
    Login to Give a bone
    0

    Default Re: Excel Table to AutoCAD Table.

    Quote Originally Posted by Lorraine.McNulty View Post
    yes that is correct. i had no problems with the first 15 tables. I even tried combining some tables to be only 12, but "table / insert from datalink / create new datalink" still locks me up every time........short of upgrading to 2009 or 2010 (not gonna happen) what do i do?
    That is odd. It should have worked. you might want to check your IT guy and verify that the lastest service pack has been installed. How many cells are in your Excel file are any of the data link tables exceeding 2000 cells. that is a cut off number for AutoCAD . The large these table are the lower AutoCAD moves. Is there another computer you can use with more RAM and better processor that may make the difference? other than that I'm out of ideas.

  6. #16
    Member
    Join Date
    2009-04
    Posts
    7
    Login to Give a bone
    0

    Default Re: Excel Table to AutoCAD Table.

    Quote Originally Posted by Capt. Computer Crasher View Post
    That is odd. It should have worked. you might want to check your IT guy and verify that the lastest service pack has been installed. How many cells are in your Excel file are any of the data link tables exceeding 2000 cells. that is a cut off number for AutoCAD . The large these table are the lower AutoCAD moves. Is there another computer you can use with more RAM and better processor that may make the difference? other than that I'm out of ideas.
    latest service pack has been installed
    fastest processor and most ram in the 50+ computers here
    BUT my spreadsheet is way over 2000 cells
    largest named range to which a datalink links=500 cells
    i hate to do it but i may have to add the tables 'cutandpaste' in which case they will no longer be dynamic

  7. #17
    All AUGI, all the time Capt. Computer Crasher's Avatar
    Join Date
    2006-12
    Location
    South of North & East of West
    Posts
    786
    Login to Give a bone
    0

    Default Re: Excel Table to AutoCAD Table.

    Quote Originally Posted by Lorraine.McNulty View Post
    latest service pack has been installed
    fastest processor and most ram in the 50+ computers here
    BUT my spreadsheet is way over 2000 cells
    largest named range to which a datalink links=500 cells
    i hate to do it but i may have to add the tables 'cutandpaste' in which case they will no longer be dynamic
    Here's a latest ditch idea try inserting each data link in its own drawing then X-referencing them all into a main drawing that may preserve some memory and the Excel sheet stays linked

  8. #18
    Member
    Join Date
    2009-04
    Posts
    7
    Login to Give a bone
    0

    Default Re: Excel Table to AutoCAD Table.

    OK i will try that when i get back to the office on monday and i'll let you know

    thanks


  9. #19
    Woo! Hoo! my 1st post
    Join Date
    2009-05
    Posts
    1
    Login to Give a bone
    0

    Default Re: Excel Table to AutoCAD Table.

    HOW TO REMOVE THIS DATA LINK FILE FROM XREF IN AUTOCAD

  10. #20
    All AUGI, all the time Capt. Computer Crasher's Avatar
    Join Date
    2006-12
    Location
    South of North & East of West
    Posts
    786
    Login to Give a bone
    0

    Default Re: Excel Table to AutoCAD Table.

    Quote Originally Posted by sajeer.ts View Post
    HOW TO REMOVE THIS DATA LINK FILE FROM XREF IN AUTOCAD
    Not sure what you are asking exactly. Are you wanting to remove a datalink from a drawing? or do you have a datalink in a drawing and that drawing is xrefed to a second drawing but you don't want the datalink to show in the xrefence list of second drawing?

    if it is the first one:
    1) First make sure the datalink is not being used. if it is being used, click on a cell in the table that is using the datalink. right-click then choose DATALINK >>detach datalink. this will detach the datalink from the table.
    2) Second type DATALINK. This will display the Data Link Manager.
    3) Highlight the datalink you wish to delete.
    4) Right click and pick delete.
    5)click "OK" to close the Data Link Manager

    if it is the second one:
    to my knowledge, there is not a way to do this without doing the steps above first and that may not be an option for you. These answers are based on AutoCAD200. I do not know if AutoCAD2009 or AutoCAD2010 can do it.

Page 2 of 3 FirstFirst 123 LastLast

Similar Threads

  1. Replies: 11
    Last Post: 2022-11-30, 03:18 PM
  2. 2014: Autocad table from Excel Data Link
    By sovby254640 in forum AutoCAD General
    Replies: 4
    Last Post: 2014-08-07, 11:19 PM
  3. Trouble with Excel Information to AutoCAD Table
    By CADdancer in forum AutoCAD Tables
    Replies: 2
    Last Post: 2010-09-08, 08:21 PM
  4. How to import excel table to autocad
    By mandy in forum AutoCAD General
    Replies: 5
    Last Post: 2008-10-31, 06:32 PM
  5. Need Help, Trying to use excel formulas in AutoCAD Table
    By ReachAndre in forum AutoCAD General
    Replies: 2
    Last Post: 2008-08-04, 02:45 PM

Posting Permissions

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