SOLVED

Break Links isn't working, and I can't find my link even after downloading the "Find Links" add-in

New Contributor

Apparently there's a link in my workbook. 

Robert_Wasiuk_1-1676933550017.png

When I select it and click "Break Link", I get this:

Robert_Wasiuk_2-1676933633018.png

When I hit "Break Links", this dialouge box disappears and nothing happens.

 

I download, unblocked, and activated the Find Links add-in, but it's grayed out.

Robert_Wasiuk_0-1676933508352.png

 

What should I try next? Thanks.

 

7 Replies
best response confirmed by Robert_Wasiuk (New Contributor)
Solution

@Robert_Wasiuk 

You had a few sheet level named items that referred to the workbook itself. Most likely created when copying sheets. Notice in the capture how the C drive location points to my computer because the file itself is open on my C drive.

Patrick2788_0-1677022288707.png

Link free workbook is attached.

 

Thanks so much for finding those! Did you delete them? Will it mess anything up?
Also, how can I find and delete those in the future?
I deleted them. They're dupes of named items you already have as workbook level named items.