Results 1 to 9 of 9

Thread: Cannot remove Excel spreadsheet reference 2008

  1. #1
    Active Member
    Join Date
    2002-01
    Posts
    99
    Login to Give a bone
    0

    Default Cannot remove Excel spreadsheet reference 2008

    I previously linked an excel spreadsheet to my drawing using AutoCAD 2008.

    Realizing that I really should only be using this drawing in the 2004 file format, I tried to detach the spreadsheet. Previous to this I deleted the spreadsheet. So in AutoCAD 2008 I tried to detach it, but got a message indicating the file is not found. It did not give me the option to detach it.

    Therefore I created a spreadsheet by the same name to see if it would then allow me to detach it. I got this message: “Cannot reload, detach or bind.”

    Are there any suggestions on how to get rid of this?

  2. #2
    All AUGI, all the time CADDmanVA's Avatar
    Join Date
    2006-12
    Location
    New Orleans, LA
    Posts
    881
    Login to Give a bone
    0

    Default Re: Cannot remove Excel spreadsheet reference 2008

    It's possible the Dynamic Link is still set up for it. Try looking there first.
    I loved the NCS so much, I joined the committee!

    "Truth suffers from too much analysis"
    I remember AutoCAD R10

    When will Autodesk port AutoCAD to Linux?

  3. #3
    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: Cannot remove Excel spreadsheet reference 2008

    Quote Originally Posted by pmedina View Post
    I previously linked an excel spreadsheet to my drawing using AutoCAD 2008.

    Realizing that I really should only be using this drawing in the 2004 file format, I tried to detach the spreadsheet. Previous to this I deleted the spreadsheet. So in AutoCAD 2008 I tried to detach it, but got a message indicating the file is not found. It did not give me the option to detach it.

    Therefore I created a spreadsheet by the same name to see if it would then allow me to detach it. I got this message: “Cannot reload, detach or bind.”

    Are there any suggestions on how to get rid of this?
    How were you trying to detach the spreadsheet through the data link manager or just deleting the linked table?


    first if the table still existing right-click on a single cell then pick data link and detach data link. After the warning hit yes. use DATALINK command. hightlight the data link that was linked to table, right click then delete. hit ok on the data link manager. now erase the table. save the drawing. now delete the excel spreadsheet.
    Last edited by Capt. Computer Crasher; 2007-11-21 at 07:30 PM.

  4. #4
    Member
    Join Date
    2002-05
    Location
    Tomelloso (Ciudad Real) - España
    Posts
    28
    Login to Give a bone
    0

    Default Re: Cannot remove Excel spreadsheet reference 2008

    Enter in the data link manager at the Tools menu and delete it

  5. #5
    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: Cannot remove Excel spreadsheet reference 2008

    Quote Originally Posted by oria.ingen View Post
    Enter in the data link manager at the Tools menu and delete it
    DATALINK is the data link manager

  6. #6
    Active Member
    Join Date
    2002-01
    Posts
    99
    Login to Give a bone
    0

    Default Re: Cannot remove Excel spreadsheet reference 2008

    Deleting it in the Data Link Manager did the trick.
    I didn't even know it existed.
    Thanks

  7. #7
    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: Cannot remove Excel spreadsheet reference 2008

    glad we could help. just remember to detach it from the table before you delete the table, data link, or Excel file. If you don't it can cause some corruption issues.

  8. #8
    Member jmcbride.161140's Avatar
    Join Date
    2008-02
    Location
    North Seattle
    Posts
    42
    Login to Give a bone
    0

    Default Re: Cannot remove Excel spreadsheet reference 2008

    Quote Originally Posted by Capt. Computer Crasher View Post
    glad we could help. just remember to detach it from the table before you delete the table, data link, or Excel file. If you don't it can cause some corruption issues.

    OK, so what if I did delete the tables and know I have the unreferenced .dxe files?

    I cannot delete them from datalinkmanager. What can I do now?

  9. #9
    Certifiable AUGI Addict irneb's Avatar
    Join Date
    2015-11
    Location
    Jo'burg SA
    Posts
    4,512
    Login to Give a bone
    0

    Default Re: Cannot remove Excel spreadsheet reference 2008

    You're right the link is saved as a dictionary object. You'll only be able to remove them using LISP (or other). Or what I've done previously is to save the DWG to DXF. Then open in a text editor and search for those DXE filenames - modify to suit. (You may be able to delete them as well, although this may create errors if you don't delete everything referring to them.) Then after you save - reopen the DXF and save back to DWG. This method is called "Hacking" - not a very good thing to do as you can mess-up the drawing pretty badly if you make only a single mistake ... only to be used as a last resort.
    Knowledge is proportional to experience, but wisdom is inversely proportional to ego!
    My little bit of "wisdom": Hind-sight is useless, unless used to improve the next forethought!

Similar Threads

  1. How to link an excel spreadsheet
    By Iceberg in forum AutoCAD Tables
    Replies: 5
    Last Post: 2014-01-30, 04:00 PM
  2. 2014: Importing data from Excel Spreadsheet
    By bethelcad370537 in forum AutoCAD Map 3D - Import/Export
    Replies: 3
    Last Post: 2013-04-18, 11:50 PM
  3. write *.ctb to excel spreadsheet
    By Sheri_in_CA in forum AutoCAD Plotting
    Replies: 2
    Last Post: 2011-10-04, 04:47 PM
  4. Embedding Excel Spreadsheet
    By teressa.dillon in forum AutoCAD General
    Replies: 5
    Last Post: 2008-08-07, 06:49 PM
  5. Exporting to Excel spreadsheet
    By KellyR in forum Inventor - General
    Replies: 1
    Last Post: 2007-09-15, 10:15 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
  •