Trouble Deleting A DataLink

Trouble Deleting A DataLink

olszewski_lukasz7PY8Z
Observer Observer
983 Views
5 Replies
Message 1 of 6

Trouble Deleting A DataLink

olszewski_lukasz7PY8Z
Observer
Observer

Hey everyone,

I’m having trouble deleting a data link to an external Excel file. I can’t see where it is in thr file, and despite my efforts, it remains in the drawing.

Here’s what I’ve tried:

  • Deleted all objects, layers, and layouts from the drawing, leaving only layer 0.
  • Used EXPLODE, PURGE, and AUDIT.
  • Checked the Data Link Manager and it shows the Excel file as "unreferenced."
  • Attempted to delete it from the DATALINK window, but it says "You can't delete because the file is in use."

Additionally, when I use QSELECT, it indicates that there are no objects to select. However, whenever I copy anything from this drawing to another file, the Excel reference is still imported to new file.

Does anyone have any suggestions on how to resolve this issue?

Thanks in advance for your help.

 

@olszewski_lukasz7PY8Z -Moderation Team has changed the heading for more clarity. 

0 Likes
Accepted solutions (1)
984 Views
5 Replies
Replies (5)
Message 2 of 6

pendean
Community Legend
Community Legend
Accepted solution
Message 3 of 6

Kent1Cooper
Consultant
Consultant

You don't mention this, so just in case....  Can you right-click on it in the Xref manager [your image] and choose Detach?

Kent Cooper, AIA
0 Likes
Message 4 of 6

R_Tweed
Advisor
Advisor

1. Make a new temporary xlsx and save it in a known location. You will re-path your dead link to this file.

2. type datalink and edit the offending datalink, choose new path and file from step 1

4. link to range a1:b2 (plaseholder) and select ok.. make sure you select ok to close out.

5.type datalink and you should be able to delete the datalink reference.

 

0 Likes
Message 5 of 6

olszewski_lukasz7PY8Z
Observer
Observer

It worked! Thank you so much. Crazy

0 Likes
Message 6 of 6

olszewski_lukasz7PY8Z
Observer
Observer

It worked. Finally. Thank you so much

0 Likes