Excel Guides

Don't Update Links to Other Programs in Excel

If you're using Microsoft Excel, it's important to keep your links up to date so that you don't accidentally break them. Here's how to do it:

  1. Open the worksheet that contains the link you want to update.
  2. Click the cell that contains the link.
  3. On the Edit menu, click Links. This displays the Edit Links dialog box.
  4. In the Edit Links dialog box, click the link you want to update, and then click Change Source. This displays the Change Link dialog box.
  5. In the Change Link dialog box, do one of the following:

    • To update a link to another Microsoft Office program, such as Microsoft Word or PowerPoint, click (Browse for file), locate and select the file that you want to link to, and then click Update. If you want to change how often Excel updates information from this linked file, click Update Values, and then in the list next to When this workbook is opened: , click one of the options.

    • To update a link to a Web page or an Internet address, type a new address in the Address box under Link To File, or click Change Address. If you want to change how often Excel updates information from this linked file, click Update Values, and then in the list next to When this workbook is opened:, click one of the options.


(Optional): To stop linking this workbook to other programs or files, do one of the following:

  1. Click Break Link. This removes all links from this workbook except for any links within formulas. 

  2. Click Close without saving. This removes all links from this workbook and does not save any changes that you made in this dialog box.

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.