+ Reply to Thread
Results 1 to 6 of 6
  1. #1
    Full Member
    Computer Details
    jt6572's Computer Details
    Operating System:
    Windows 10
    RAM:
    8GB
    Discipline
    Civil
    jt6572's Discipline Details
    Occupation
    Civil Designer
    Discipline
    Civil
    Using
    AutoCAD 2015
    Join Date
    Jul 2015
    Location
    Brisbane Australia
    Posts
    79

    Default Data Link to Excel keeps becoming "unreferenced"

    Registered forum members do not see this ad.

    Hi all,
    i have reffed in spreadsheets for signage schedules (existing and proposed) and have done so so that they can be edited in excel and updated as per a usual x ref.
    i have done it all correctly, however today (did it friday, no issues) it just wont come back in and only ever says it is "unreferenced".
    when i reffed it in (it is two pages in the same excel doc) i made them relative path, and had no issues with "download from source" via Data Link, but today after removing them and trying again due to them not updating, then being not found (the "..\" at the front of the relative path had gone missing) i cant get them in at all now; they simply show up in the x ref manager as "unreferenced" and there is nothing in the drawing.

    i need them to be to a particular format and simply pasting them in is not what i am after as i need for my engineer to be able to update them as well.

    has anyone experienced this and have a solution? would really appreciate any help...

    thank you.
    jeff

  2. #2
    Quantum Mechanic ReMark's Avatar
    Computer Details
    ReMark's Computer Details
    Operating System:
    Windows 7 Pro 64-bit
    Computer:
    Thinkmate
    Motherboard:
    Intel DX58SO2 LGA1366 X58
    CPU:
    Intel i7-960 Quad-core 3.20GHz 8MB cache
    RAM:
    12GB (3x4GB) PC3-106000 DDR3
    Graphics:
    nVidia Quadro K4200, 4GB GDDR5
    Primary Storage:
    150GB Velocipraptor 10,000 rpm
    Secondary Storage:
    none
    Monitor:
    Dell P24LLH - 24" wide screen LCD
    Discipline
    See details...
    ReMark's Discipline Details
    Occupation
    CAD Draftsman/Designer...chemical manufacturing.
    Discipline
    See details below.
    Details
    I work for a specialty chemical manufacturer. I do a little bit of everything from P&IDs to civil to architectural and structural.
    Using
    AutoCAD 2018
    Join Date
    Nov 2005
    Location
    Norwalk, CT USofA
    Posts
    46,496

    Default

    A datalink does not require a spreadsheet to also be xreffed.
    "I have only come here seeking knowledge. Things they wouldn't teach me of in college." The Police

    Eat brains...gain more knowledge!

    I'm now a full member of the Society for the Promotion of Mediocrity in CAD. Standards? We don't need no stinkin' standards! Take whatever advice I offer and do the opposite.

  3. #3
    Luminous Being RobDraw's Avatar
    Using
    MEP 2017
    Join Date
    Apr 2007
    Location
    Connecticut, USA
    Posts
    5,169

    Default

    Unreferenced means that the path information is present in the file but the table has been deleted. Using the table command should allow you to reinsert it.
    Drafting is a breeze.

  4. #4
    Full Member
    Computer Details
    jt6572's Computer Details
    Operating System:
    Windows 10
    RAM:
    8GB
    Discipline
    Civil
    jt6572's Discipline Details
    Occupation
    Civil Designer
    Discipline
    Civil
    Using
    AutoCAD 2015
    Join Date
    Jul 2015
    Location
    Brisbane Australia
    Posts
    79

    Default

    thanks very much guys.
    i honestly cant explain it, but the spreadsheet hasnt been deleted (which is what you would think with it being "unreferenced"). i havent used this function much, so its probably just a noob thing?!
    in any case, it seems fine now, but thank you for the replies.

  5. #5
    Luminous Being RobDraw's Avatar
    Using
    MEP 2017
    Join Date
    Apr 2007
    Location
    Connecticut, USA
    Posts
    5,169

    Default

    Quote Originally Posted by jt6572 View Post
    thanks very much guys.
    i honestly cant explain it, but the spreadsheet hasnt been deleted (which is what you would think with it being "unreferenced"). i havent used this function much, so its probably just a noob thing?!
    in any case, it seems fine now, but thank you for the replies.
    So, it just fixed itself?

    By definition "unreferenced" means that it is not present in the file. Just the path is.
    Drafting is a breeze.

  6. #6
    Forum Deity Dana W's Avatar
    Computer Details
    Dana W's Computer Details
    Operating System:
    Windows 8 64 bit
    Computer:
    Dell XPS ONE 2710
    Motherboard:
    Dunno
    CPU:
    Intel I-5 3330S @ 2.7 Ghz
    RAM:
    6 Gb
    Graphics:
    On board barely adequate
    Primary Storage:
    1 Terrabyte
    Secondary Storage:
    1 Terrabyte external
    Monitor:
    All in one 27" touch & pen
    Discipline
    Construction
    Dana W's Discipline Details
    Occupation
    Architectural Millwork Designer/Draftsman
    Discipline
    Construction
    Details
    Custom commercial millwork.
    Using
    AutoCAD LT 2018
    Join Date
    Feb 2010
    Location
    Oviedo, Florida
    Posts
    4,715

    Default

    Registered forum members do not see this ad.

    Quote Originally Posted by jt6572 View Post
    thanks very much guys.
    i honestly cant explain it, but the spreadsheet hasnt been deleted (which is what you would think with it being "unreferenced"). i havent used this function much, so its probably just a noob thing?!
    in any case, it seems fine now, but thank you for the replies.
    Explicitly, "Unreferenced" means the xref or link was attached at one time, and subsequently the inserted image was erased leaving only the still attached path to the file.
    The S197 gen Ford Mustang, and the F-4 Phantom both prove the same theory. "With enough power applied, a school bus will fly."

Similar Threads

  1. Replies: 21
    Last Post: 14th Jul 2014, 07:04 am
  2. Importing Excel data and draw lines (Data is "From" "To" ponts of Line or length
    By pvsvprasadcivil in forum AutoLISP, Visual LISP & DCL
    Replies: 8
    Last Post: 28th Dec 2013, 10:37 am
  3. Export properties ("measurement") of "Aligned Dimension" to Excel
    By nhatquyelec in forum AutoLISP, Visual LISP & DCL
    Replies: 8
    Last Post: 1st Feb 2013, 07:58 am
  4. Excel Data Link in Civil 3D unreferenced.
    By soozyq in forum Civil 3D & LDD
    Replies: 0
    Last Post: 22nd Aug 2012, 12:31 am
  5. "LINK template" icons "greyed out" -why?
    By Chrisjpritchard in forum AutoCAD Drawing Management & Output
    Replies: 0
    Last Post: 2nd Mar 2007, 10:25 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