Excel for Office Excel Excel Excel Excel Excel More Less Change the source workbook for all external references that use it. If you use an external data range, a parameter in the query may be using data from another On the Data tab, in the Connections group, click Edit Links. Familiar way to apply Edit Links and Break Links if you have Classic Menu for out the Edit links command in Microsoft Excel , , , and
If you are using an earlier version (Word or earlier), this tip may not work for you. For a version of For instance, you may have an Excel workbook you start over every year. Save the document and the Edit Links will then be available. Excel allows you to change your link so it can point to the proper file as Use the controls in the dialog box to locate and select the file that will. How to insert a hyperlink using the Excel On the Insert tab, in the Links group, click the.
To change the source link you have to use the “Edit Links” option. This option gives the user a view of all the other files the current file is linked to, so that the user. On our Excel financial modelling courses we always advise training delegates to keep models self-contained, with no links to external.