Change the source of a link

ShowChange the source workbook for all links that use the source

  1. Open the workbook that contains the link.
  2. On the Edit menu, click Links.
  3. In the Source box, click the name of the link whose source you would like to change.
  4. Click Change Source.
  5. In the Change Source dialog box, click the source workbook (source file: The file that contains information that was used to create a linked or embedded object. When you update the information in the source file, you can also update the linked object in the destination file.) you want to refer to.

ShowChange the source of one link without affecting other links that use the source

  1. Select the cell with the link.
  2. In the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.) Formula bar, look for a reference to another workbook, such as C:\Reports\[Budget.xls], and change it to the name of the new workbook.
 
 
Applies to:
Excel 2003