Results 1 to 2 of 2

Thread: Using Excel Spreadsheets in AutoCAD 2010

  1. #1
    Woo! Hoo! my 1st post
    Join Date
    2011-04
    Posts
    1
    Login to Give a bone
    0

    Default Using Excel Spreadsheets in AutoCAD 2010

    We are using AutoCAD 2010. I am a self taught user with almost no training. I have spreadsheets that I have created in Excel 2010 that complete many engineering calculations yet output the information in a format that is suitable for inserting in a construction drawing as a table. When I link the Excel file to a drawing and inset the range of cells included in my print range, it does not insert with all formating. I basically want it to look just like the document I would print from Excel but I want it to update the information each time I open the drawing file. That way, I can still make use of the calculations built into the spreadsheet but not have to worry about manually making the changes in the drawing if an Excel file is updated.

    I would love to know if this is possible and if so, some direction on how to do this.

    Thanks,

  2. #2
    Member
    Join Date
    2011-03
    Posts
    3
    Login to Give a bone
    0

    Default Re: Using Excel Spreadsheets in AutoCAD 2010

    Hi Richard,
    I hope I am understanding your question correctly. I am assuming that you have a general knowledge of AutoCAD 10.

    Before trying the 'cut & paste' method (assuming that is what you did)

    Try:
    _INSERTOBJ
    Select the radio button 'Create from File'
    click on 'Link'
    then click on 'Browse...'

    The 'Link' should update every time you make changes to the 'Excel'

    Let me know how that works for you.

Similar Threads

  1. Replies: 5
    Last Post: 2013-10-16, 05:39 PM
  2. Excel Spreadsheets
    By pdavis in forum Revit Architecture - General
    Replies: 8
    Last Post: 2008-03-27, 10:50 PM
  3. Excel Spreadsheets in AutoCAD 2002
    By kregor77 in forum AutoCAD General
    Replies: 2
    Last Post: 2004-10-14, 02:25 PM
  4. INSERTING EXCEL SPREADSHEETS
    By howard.16379 in forum ACA General
    Replies: 1
    Last Post: 2004-09-17, 02:45 PM
  5. Replies: 3
    Last Post: 2004-09-15, 01:02 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
  •