Results 1 to 7 of 7

Thread: Linking Excel spreadsheet to AutoCAD

  1. #1
    Member
    Join Date
    2007-12
    Posts
    3
    Login to Give a bone
    0

    Default Linking Excel spreadsheet to AutoCAD

    I am trying to link an Excel Spreadsheet to AutoCAD. The problem I have is that only
    half the spreadsheet is copied into AutoCAD. Does anyone have any suggestions?

  2. #2
    Super Moderator rkmcswain's Avatar
    Join Date
    2004-09
    Location
    Earth
    Posts
    9,696
    Login to Give a bone
    0

    Default Re: Linking Excel spreadsheet to AutoCAD

    What version of AutoCAD are you using?
    R.K. McSwain | CAD Panacea |

  3. #3
    Member
    Join Date
    2007-12
    Posts
    3
    Login to Give a bone
    0

    Default Re: Linking Excel spreadsheet to AutoCAD

    I am using AutoCAD 2007, I am not sure what version of Excel

  4. #4
    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: Linking Excel spreadsheet to AutoCAD

    Quote Originally Posted by dmcdonald.156724 View Post
    I am trying to link an Excel Spreadsheet to AutoCAD. The problem I have is that only
    half the spreadsheet is copied into AutoCAD. Does anyone have any suggestions?
    You can only LINK Excel as a an Excel spreadsheet in AutoCAD 2007 which has a limit on the amount of data. If you just copy/paste the spreadsheet as an AutoCAD identity you can better results. There is a limit of (I think) 10,000 or 20,000 thousand cells.

    If you want to link in 2007 you may have to make two tables.

  5. #5
    Member
    Join Date
    2007-12
    Posts
    3
    Login to Give a bone
    0

    Default Re: Linking Excel spreadsheet to AutoCAD

    Thank you for your help. The spreadsheet is only 75 rows and maybe 20 columns.
    I want to link it for the edit function, as we are using it for our building code analysis.

  6. #6
    Super Moderator rkmcswain's Avatar
    Join Date
    2004-09
    Location
    Earth
    Posts
    9,696
    Login to Give a bone
    0

    Default Re: Linking Excel spreadsheet to AutoCAD

    R2008 allows you to link an Excel spreadsheet to an AutoCAD Table entity. That doesn't help you any now, but it may down the road.

    You might take a look at XL2CAD. We have used this with success in the past. Not that it doesn't still work, but our need to link spreadsheets has all but vanished recently.
    R.K. McSwain | CAD Panacea |

  7. #7
    Member
    Join Date
    2007-10
    Posts
    44
    Login to Give a bone
    0

    Default Re: Linking Excel spreadsheet to AutoCAD

    Copy and paste works best for me....

    I highlight the spread sheet in Excel, then in Autocad I use paste....hope this helps.

Similar Threads

  1. Excel spreadsheet linking problem
    By tlepird2925761 in forum Inventor - General
    Replies: 15
    Last Post: 2019-03-12, 10:18 AM
  2. Link text in Autocad with an Excel spreadsheet
    By wiegmanroger433258 in forum AutoLISP
    Replies: 8
    Last Post: 2017-07-31, 12:11 AM
  3. Linking object in a drawing to an external Excel Spreadsheet
    By bethelcad370537 in forum Facilities Management In Practice
    Replies: 7
    Last Post: 2013-04-16, 01:34 PM
  4. Excel Spreadsheet and AutoCAD 2005
    By daveng in forum AutoCAD Customization
    Replies: 1
    Last Post: 2005-09-09, 04:05 PM
  5. Excel Spreadsheet wrong size insert & Linking
    By 3D Jack in forum AutoCAD General
    Replies: 3
    Last Post: 2005-07-11, 10:38 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
  •