Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.

Trouble Deleting A DataLink

olszewski_lukasz7PY8Z
Observer

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
Reply
Accepted solutions (1)
657 Views
5 Replies
Replies (5)

pendean
Community Legend
Community Legend
Accepted solution

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

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

olszewski_lukasz7PY8Z
Observer
Observer

It worked! Thank you so much. Crazy

0 Likes

olszewski_lukasz7PY8Z
Observer
Observer

It worked. Finally. Thank you so much

0 Likes