This command will not be available in all instances. If it is, you will probably have Formula Links. There may be more than one file linked. Upon inspection, you may notice that one or more file may simply be an older version of the active workbook. This will remove these referencing errors. Some files you may not have access to and may cause errors if the file is inadvertently updated. By selecting the Break Link button, these links can be replaced by their current values N.
This action cannot be undone — you may wish to save the file beforehand in order to rectify errors. If you do have formula links, it is relatively straightforward to search for these links:.
This is probably the most common cause of phantom links: names that reference ranges in other workbooks. By scrolling through the list of names and examining the Refers To section a little cumbersome prior to Excel , admittedly , names referring to other workbooks or containing erroneous references such as REF! If you have charts in your workbook, there are various places where hidden links could be lurking.
Click on each text box or title and examine the formula bar for references to other workbooks. These links can be removed by copying as values the data located into the active workbook.
Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted. No edit links tool appears I'm using one, as usual these blogs are a waste of time! What if I want to just update the links to a new tab in the same excel file? Is that still possible to chose the tab you want to update to?
What if the source file that I needed is saved in a Share Point? How can I make that as my source file? When I click the change source, it's only showing me files from my hard drive.
Pls help and advise. 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. 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.
A5 But if cells in "other-workbook" are referenced in data validation or conditional formatting, the "Change Source You'll have to chase those down yourself and fix them manually.
I learned these two cases specifically with workbooks I use, and fixed it by creating a links section. What I did was put links into cells [Workbook-A]other-tab! U45, and then change the Data Validation Source to point to that set of cells. The contents of the links section are updated properly by the Change Source button. The frustrating part is that there is no easy way or at least I don't know any to find the data validations or conditional formatting that cause this.
You just have to walk through the whole workbook looking for them. Thank you. I had to move some files around on the network for a coworker to cover for me, and broke all my workbooks. It's taking time to fix them but I now know how. It is happening perfectly fine for my colleague. Got a version of Excel that uses the ribbon interface Excel or later? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
View the most recent newsletter. Sorry this didn't help. Thanks for your feedback. How satisfied are you with this reply?. Thanks for your feedback, it helps us improve the site.
Choose where you want to search below Search Search the Community. MsExcel This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread. I have the same question Report abuse. Details required :.
0コメント