Excel Guides

Updating Links in Excel

Updating links in Excel can be a tedious and time-consuming task, especially if you have a lot of links to update. However, there are a few ways that you can make this task easier and less time-consuming.

One way to update links in Excel is to use the Find and Replace feature. To do this, open the Find and Replace dialog box by pressing Ctrl+F or by going to Home > Editing > Find & Select > Find. In the Find what field, type the old link that you want to replace. In the Replace with field, type the new link. Then click the Replace All button.

Another way to update links in Excel is to use a macro. There are a few different macros that you can use to update links, but we'll just focus on one here. To use this macro, first open the Visual Basic Editor by pressing Alt+F11 or by going to Developer > Code > Visual Basic. Then insert a new module by going to Insert > Module. Paste the following code into the module:

Sub UpdateLinks() 
 Dim lnk As Link 
 For Each lnk In ActiveWorkbook.Links 
     lnk.Update 
 Next lnk 
End Sub

To run the macro, press F5 or go to Run > Run Sub/UserForm. The macro will loop through all of the links in the active workbook and update them.

One final way to update links in Excel is to use a third-party tool such as Link Manager from AbleBits (https://www.ablebits.com/office-addins-blog/2014/01/16/update-links-excel/#linkmanager). This tool makes it easy to manage all of your links in one place and makes it easy to update them with just a few clicks.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.