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. You already know that Excel allows you to establish links between your workbook and other objects, such as graphics, Word documents, and other items.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |