Other times, the link is created intentionally, but without the intent to harm. So you may open a Workbook from a broker, who in modeling a particular deal linked to data on a separate workbook without understanding how to avoid creating external links.Ĭheck out our ‘ Best Practices in Real Estate Financial Modeling‘ post for how to avoid accidentally creating external links This usually occurs when a user borrows logic from a separate workbook in creating the workbook you’re now opening, and in doing so inadvertently leaves one or more links back to the first workbook. Most often, these links are benign and were unintentionally added to the Workbook. This is because the Workbook you’re attempting to open has a link to a different Workbook that is located either on your computer, on a local server, on another user’s computer, or on a remote server. If you’ve ever opened Excel files shared with you by a co-worker, broker, or source online, you’ve likely come across the “ this workbook contains links to one or more external sources that could be unsafe” alert. Why Does This Occur? Excel Workbooks with External Links Select the macro you have made, it should have the name ‘RemoveAllHyperlinks’.In this tutorial, I show you how to permanently remove that annoying “This workbook contains links” alert.Run the macro by pressing Alt+F8 or using the menu by View -> Macros.If you want to remove selected multiple hyperlinks using VBA, copy this code: Sub RemoveSelectedHyperlinks() Double click the workbook you are using on the Project Explorer and type the following code:.Press Alt+F11 to start the Visual Basic Editor.Remove Hyperlinks Remove the hyperlinks and formatting from the selected cells. What's the difference between Clear Hyperlinks and Remove Hyperlinks? Clear Hyperlinks Clear the hyperlinks from the selected cells. if you want to only clear the hyperlinks but not remove the formatting, choose Clear Hyperlinks.Click Home, move to Editing group and click the down arrow next to the Clear button.Select the range containing hyperlinks that you want to remove.How To Remove Multiple Hyperlinks In Excel 2007 and Later

This tip only remove hyperlinks, not remove formatting, formulas or others. Note: this tip works well in excel 2003 (not support Excel 2007, 2010, 2013).

Disable links in excel spreadsheet