Edit Links

When user create external references between workbooks to bring information from a source workbook into a destination workbook, it might be very difficult to manually trace all links specially if the workbook has a vast external references.One very helpful tool to workaround with it is using Edit Links which can be access under Tools in the ribbon (this opens the edit link window without restriction as the sheet is locked).

Edit Links manager will open if your sheet contains some external references and it display all the files to which your spreadsheet is linked to;

Here, you can:

• verify the workbook you want the external reference to point to is correct
• change the source workbook in an external reference
• remove formulas
• update values.