What I did was put links into cells other-tab!B105:B145, containing =tab!U5, =tab!U6. Data Validation on a cell in Workbook-A was set to Allow: List, Source: =tab!U5:U45. I learned these two cases specifically with workbooks I use, and fixed it by creating a links section. You'll have to chase those down yourself and fix them manually. Īll formulae like this: =tab!A5 will be changed to =tab!A5īut if cells in 'other-workbook' are referenced in data validation or conditional formatting, the 'Change Source.' button won't update those references. The problem is that a workbook can be connected to another workbook in several ways - that other workbook will appear in the Edit Links list as long as any of those connections exist, but the Change Source button only updates links found in cell formulae. In (belated) reaction to Adi's question, note that this can happen for all sorts of reasons, and they can be rather subtle, confusing, and frustrating. Make any additional link changes necessary by repeating steps 2 through 5.Excel updates the link to reflect the new source you specified. Use the controls in the dialog box to locate and select the file that will serve as the new source of the link.Excel displays the Change Source dialog box. Excel displays the Edit Links dialog box. In the Connections group (Excel 2007, Excel 2010, and Excel 2013) or the Queries & Connections group (Excel 2016), click the Edit Links tool.To change links in this manner, follow these steps: Excel allows you to change your link so it can point to the proper file as the source of the object in the workbook. For instance, you may have a picture linked in your workbook, and you want to change the location of the picture (to a different directory or drive). (We're talking regular links here, not hyperlinks.) There may come a time when you wish to change the links. This is a simple little trick that will save you a lot of time when you have to clean-up a worksheet.ĭownload the sample worksheet attached to this tutorial to try this out in Excel.You already know that Excel allows you to establish links between your workbook and other objects, such as graphics, Word documents, and other items. Click the upper left corner of the spreadsheet to select the entire worksheet.Go to the Home tab and look to the right and click the small white eraser button and then click Remove Hyperlinks.Do this without navigating to the link by right-clicking the cell and then hitting the Esc (Escape) key to remove the menu that appears when you right-clicked the cell. Select the cell that contains the hyperlink.

Remove All Hyperlinks from a Worksheet at Once This removes the link itself and any associated formatting but keeps the visible text in place.

How to quickly remove all hyperlinks or a selection of hyperlinks from Excel.

Edit multiple hyperlinks in excel 2016