If you want to remove, break or unlink external links in Excel, this post will show you how to do it. You can also break multiple or all links.

This action will remove all links from your workbook but leave your formulas intact so your recipients can still edit the data to produce “what-if ” scenarios for deeper analysis.

Now by doing this, we will end up breaking the links that call on other Excel spreadsheets being that the UNC path will change.

Q: I can’t figure out why the “Page break between groups” option in the attached Excel 2013 workbook doesn’t work; this page break functionality seems to work fine in all of my other workbooks, just ...