Excel Cannot Break Link
Here we will provide two methods to find out the Edit links command in Microsoft Excel 2007, 2010, 2013, 2016, 2019 and 365. Familiar way to apply Edit Links and Break Links if you have Classic Menu for Office. If you have installed Classic Menu for Office, you will discover the Edit Links and Break Links commands stay in a familiar environment. You can select each file listed then click 'break links' and excel will replace the formulas that contain external links with values. The problem with this feature is you will not always know which formulas you are editing and the feature does not work on some links. 2) If you want to view each external link before editing it another option is to search for all external links. Method A: Find out the Edit Links and Break Links command from Edit menus Click the Menus tab; Click the Edit drop down menu; Then you will view the Edit Links to Files, as the figure we show you at the right side.
Excel Cannot Break Link Source Not Found
How To Find Broken Links In Excel
Removing Phantom Excel LinksIf you have ever opened an Excel file and been prompted to update links to another file, yet you are certain that there are no links to any other files, your file may contain phantom links.To remove Phantom Links from a workbook, first check to make sure that there are not any non-phantom links in the file.