Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
Macros to delete formula links in Excel for Mac
Article ID: 192895 - View products that this article applies to.
This article was previously published under Q192895
For a Microsoft Excel 97 and earlier version of this article, see 126093
When you open a workbook that contains links to another workbook, Microsoft Excel asks you if you want to update links. If the file that the link is referring to no longer exists, or if it has been moved to a different folder, you may want to delete the links to avoid this message.
One of the most common link types is a formula link. A link formula in a cell can refer to a cell on a closed workbook file. If that file no longer exists, the formula is no longer valid. To delete such a link, click Find on the Edit menu, and search for an (!) exclamation point. Or, if this action fails, search for a ([ ]) square bracket. This will show each link in a sheet. You can then go to each cell, delete the formula, and replace it with the value that was in the cell. If many cells contain links, deleting the links may take some time. To speed up the deletion process, you may want to use one of the following methods. The macros will enable you to delete some links and not others. It does not delete links to workbooks that are open or within the active workbook.
NOTE: These macros may not work if the source file for a link is located on a network drive. If this is the case, the link will be found but not deleted.
Visual Basic Code ExampleMicrosoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements.