Maximizing Connectivity & Productivity

Excel – Changing the link source

If your source workbook changes, you may need to change your external references.  For example if your original source file was Annual Sales, but the final file is then called Annual Sales 2012.

To change the link source, use the Edit Links dialog box.  File-> Info -> Related Documents -> Edit Links to Files.  Select the source workbook to change and click the Change Source button.  Excel then displays the Change Source dialog box from which you can select the new source file.  Once the file is selected, all external reference formulas that referred to the old file are updated.

Leave a Reply

You must be logged in to post a comment.

Mississauga, ON, Canada 905.607.3500