However, sometimes users encounter an error where the excel function to break links is not working. If you can’t break all reference links in an Excel file, check out some of the resolutions below.
How to fix the Excel function break links is not working?
1. Unprotect the Excel worksheet
2. Delete named cell ranges
3. Clear all data validation rules from the sheet
4. Check out the Break Link Excel add-in
The Break Link Tool is an Excel add-in with which you can quickly remove all reference links from an Excel worksheet. The add-in is not freely available, but you can still try out the add-in with a one-week free trial. Click the Download button on the Break Link Tool page to install that add-in. With that add-in installed, you’ll see a Break Links button on the Home tab. Click that button to open the tool’s window. Then you can click a Select all option to select all the tool’s break link settings. Pressing the Start button will remove all the links. So, that’s how you can break links in your sheet when you can’t get rid of them with the Edit Links tool. Note that spreadsheet objects and pivot tables might also include referral links. So, also check if any objects and pivot tables on sheets have any reference links. Which one of these methods worked out for you? Let us know by leaving a message in the comments section below.
SPONSORED
Name *
Email *
Commenting as . Not you?
Save information for future comments
Comment
Δ
