A frustrating problem for many users
How do I break links in Excel?
If you work in Excel, you may have come across a situation where you can't break links to external references. This can be frustrating, especially if you want to update your data sources or share your workbook without sharing the source files.
But don’t worry, there are a number of solutions you can try to break those stubborn links, free up your Excel data and make your workbook independent. If you can’t break links in Microsoft Excel, follow the steps below.
Before we get into the solutions, we need to understand why break links don’t work in the first place. When you link data from another workbook or worksheet, Excel creates a connection that allows you to update the data automatically. Sometimes, however, you want to break this connection and keep only the values in your workbook.
