+ Reply to Thread
Results 1 to 5 of 5
  1. #1
    Full Member
    Using
    AutoCAD 2015
    Join Date
    Aug 2013
    Posts
    88

    Default Excel table in drawing is not updating

    Registered forum members do not see this ad.

    Hello all,
    I inserted a table from excel to autocad with copy-edit/paste special/paste link/microsoft excel worksheet(code) and everything seems to work nice until I closed the excel. After that no automatic updates to cad files.
    Do you know why, and how can I fix that?

    Thank you.

    PS: I checked the properties of the excel table and it is linked.

  2. #2
    Luminous Being tzframpton's Avatar
    Computer Details
    tzframpton's Computer Details
    Computer:
    HP Zbook
    Discipline
    Multi-disciplinary
    tzframpton's Discipline Details
    Occupation
    BIM Specialist
    Discipline
    Multi-disciplinary
    Details
    Full Virtual Design and Construction BIM services for the MEP engineering and construction industries.
    Using
    Revit 2019
    Join Date
    Mar 2006
    Location
    Dallas, TX - USA
    Posts
    9,104

    Default

    I would use DATALINK instead. More robust in both options and functionality, and can be bi-directional.
    Tannar Z. Frampton â„¢ | Frampton & Associates, Inc.

  3. #3
    Full Member
    Using
    AutoCAD 2015
    Join Date
    Aug 2013
    Posts
    88

    Default

    I have everything setup this way .
    Is there a solution to this problem?

  4. #4
    Forum Deity steven-g's Avatar
    Computer Details
    steven-g's Computer Details
    Operating System:
    Win 7
    Discipline
    Construction
    steven-g's Discipline Details
    Occupation
    Draughtsman
    Discipline
    Construction
    Details
    I work in the estimating department of a large building contractor.
    Using
    AutoCAD 2018
    Join Date
    May 2013
    Location
    An Englishman in Belgium
    Posts
    2,149

    Default

    Are your links set to update automatically MENU-EDIT-OLE LINKS the dialogue should show the linked excel file location, but can be set to update manualy

  5. #5
    Senior Member
    Using
    AutoCAD 2017
    Join Date
    Jun 2013
    Posts
    139

    Default

    Registered forum members do not see this ad.

    Quote Originally Posted by tazzzz View Post
    I have everything setup this way .
    Is there a solution to this problem?
    Yeah, don't close excel

    If the cad file is closed, and the excell file is modified, saved, and closed, the cad file should be updated next time it is opened.

    If excel is not open, then the excel file won't be changed, so why would it update? Is someone else is updating the file?

Similar Threads

  1. Updating between excel sheet and autocad dwg.
    By Jach in forum AutoCAD Drawing Management & Output
    Replies: 30
    Last Post: 12th Mar 2012, 10:58 am
  2. Copy Excel Table Into AutoCAD Drawing
    By Bill Tillman in forum AutoLISP, Visual LISP & DCL
    Replies: 0
    Last Post: 25th Feb 2012, 04:21 am
  3. Replies: 3
    Last Post: 13th Feb 2012, 06:09 pm
  4. Excel to CAD Table
    By d_sut in forum AutoCAD General
    Replies: 3
    Last Post: 26th Apr 2010, 08:55 pm
  5. updating tables from autocad to excel
    By chelsea1307 in forum AutoCAD General
    Replies: 8
    Last Post: 11th Feb 2009, 06:46 pm

Bookmarks

Posting Permissions

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