Update Links Window

%3CLINGO-SUB%20id%3D%22lingo-sub-1461597%22%20slang%3D%22en-US%22%3EUpdate%20Links%20Window%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1461597%22%20slang%3D%22en-US%22%3E%3CP%3EI%20keep%20getting%20the%20yellow%20%22Update%20External%20Links%22%20bar%20at%20the%20top%20of%20my%20spreadsheet%20but%20I%20have%20searched%20in%20the%20cells%20using%20the%20Find%20command%20window%20under%20the%20%22Formulas%22%20option%20for%20any%20external%20links.%20I%20used%20for%20the%20search%20criteria%20keywords%20that%20are%20in%20the%20reference%20given%20by%20the%20%22Update%20Values%22%20window%20after%20clicking%20on%20%22Update%22%20in%20the%20yellow%20bar.%20But%20there%20are%20none.%20I%20have%20also%20searched%20in%20the%20hidden%20sheets.%20There%20are%20none.%20But%20I%20keep%20getting%20%22Update%22%20in%20the%20top%20yellow%20bar.%20I%20do%20have%20links%20but%20to%20a%20single%20spreadsheet%20that%20is%20present%20in%20the%20same%20workbook%20I%20am%20working%20in.%20How%20do%20I%20get%20rid%20of%20the%20%22Update%22%20in%20the%20top%20yellow%20bar%3F%20or%20what%20other%20methods%20are%20available%20to%20search%20for%20external%20links%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1461597%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1461760%22%20slang%3D%22en-US%22%3ERe%3A%20Update%20Links%20Window%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1461760%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F698871%22%20target%3D%22_blank%22%3E%40Lnjec%3C%2FA%3E%26nbsp%3BTry%20the%20tool%20you'll%20find%20in%20the%20attached%20link.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fmanville.org.uk%2Fsoftware%2Ffindlink.htm%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmanville.org.uk%2Fsoftware%2Ffindlink.htm%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1463036%22%20slang%3D%22en-US%22%3ERe%3A%20Update%20Links%20Window%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1463036%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BThank%20you%20for%20helping%20me.%20I%20have%20installed%20the%20add-in%20it%20now%20appears%20at%20the%20top%20left%20of%20the%20screen%20at%20the%20File%20command%20as%20%22Find%20Links%22%20with%20a%20magnifying%20glass.%20It%20started%20to%20work%20and%20gave%20me%20a%20very%20long%20list%20of%20cells%20that%20are%20all%20under%20a%20single%20column%20when%20I%20went%20there%20there%20were%20no%20links%20in%20those%20cells.%20But%20now%20when%20I%20click%20on%20the%20%22Find%20Links%22%20I%20get%20the%20following%20message.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Lnjec_0-1592217911790.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F198809iC6ECA27B8C05F6B7%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Lnjec_0-1592217911790.png%22%20alt%3D%22Lnjec_0-1592217911790.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThis%20is%20also%20happening%20on%20another%20spreadsheet%20that%20I%20tried%20it%20on%20where%20I%20have%20the%20same%20problem%20with%20unidentified%20external%20links.%20But%20this%20time%20I%20go%20straight%20to%20receiving%20the%20above%20message%20without%20getting%20a%20list%20of%20cells%20that%20I%20got%20when%20I%20first%20ran%26nbsp%3B%22Find%20Links%22%20on%20the%20previous%20spreadsheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1466711%22%20slang%3D%22en-US%22%3ERe%3A%20Update%20Links%20Window%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1466711%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F698871%22%20target%3D%22_blank%22%3E%40Lnjec%3C%2FA%3E%26nbsp%3BDifficult%20to%20diagnose%20and%2For%20duplicate%20the%20error%20without%20the%20file.%20I'm%20not%20a%20heavy%20user%20of%20the%20tool%20myself%2C%20but%20it%20has%20been%20recommended%20in%20this%20forum%20many%20times.%20Perhaps%20you%20can%20contact%20the%20authors%20directly%20from%20their%20web-site.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1467259%22%20slang%3D%22en-US%22%3ERe%3A%20Update%20Links%20Window%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1467259%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BThanks.%20I'm%20the%20author%2C%20can%20I%20send%20you%20the%20file%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1467411%22%20slang%3D%22en-US%22%3ERe%3A%20Update%20Links%20Window%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1467411%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F698871%22%20target%3D%22_blank%22%3E%40Lnjec%3C%2FA%3E%26nbsp%3BI%20meant%20that%20you%20could%20perhaps%20contact%20the%20author%20of%20the%20tool%2C%20via%20their%20web-site.%20But%20feel%20free%20to%20send%20me%20the%20file.%20I%20can%20have%20a%20try.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1481075%22%20slang%3D%22en-US%22%3ERe%3A%20Update%20Links%20Window%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481075%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%2C%20I%20have%20attached%20a%20file%20with%20the%20problem.%20There%20is%20also%20another%20problem%20with%20this%20file%20which%20is%20a%20circular%20formula%20that%20I%20can%20not%20find.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1481083%22%20slang%3D%22en-US%22%3ERe%3A%20Update%20Links%20Window%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481083%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F698871%22%20target%3D%22_blank%22%3E%40Lnjec%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECircular%20references%20are%20shown%20at%20the%20left%20of%20the%20status%20bar%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20303px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200052i114A8F16D5017D27%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1481115%22%20slang%3D%22en-US%22%3ERe%3A%20Update%20Links%20Window%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481115%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThank%20you%20I%20did%20not%20know%20the%20circular%20formulas%20cells%20were%20identified%20at%20the%20bottom%20of%20the%20spreadsheet%2C%20thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1481366%22%20slang%3D%22en-US%22%3ERe%3A%20Update%20Links%20Window%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481366%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F698871%22%20target%3D%22_blank%22%3E%40Lnjec%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20for%20the%20external%20link%20-%20it%20is%20in%20cell%20Wk06!AE5%20in%20data%20validation.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20422px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200089i4D6092EE42C92DE7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eand%20in%20other%20cells%20down%20(AE9%2C%20etc.).%20In%20attached%20file%20data%20validation%20is%20erased%20for%20this%20column.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1481770%22%20slang%3D%22en-US%22%3ERe%3A%20Update%20Links%20Window%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481770%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThank%20you.%20I%20just%20selected%20the%20whole%20sheet%20and%20cleared%20all%20validations.%20Is%20it%20possible%20with%20the%20Excel%20available%20features%20to%20be%20able%20to%20find%20each%20cell%20individually%20with%20external%20Validation%20links%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1481973%22%20slang%3D%22en-US%22%3ERe%3A%20Update%20Links%20Window%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481973%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F698871%22%20target%3D%22_blank%22%3E%40Lnjec%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENope%2C%20that's%20third-party%20tools%20like%20FindLink.%20I've%20seen%20you%20tried%20it%2C%20don't%20know%20why%20it%20didn't%20help.%20In%20general%20it%20works%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20413px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200157iF5DCEFB1AB6918AB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1482124%22%20slang%3D%22en-US%22%3ERe%3A%20Update%20Links%20Window%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1482124%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BMaybe%20FindLink%20didn't%20work%20because%20I%20am%20working%20on%20Excel%20via%20VPN.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I keep getting the yellow "Update External Links" bar at the top of my spreadsheet but I have searched in the cells using the Find command window under the "Formulas" option for any external links. I used for the search criteria keywords that are in the reference given by the "Update Values" window after clicking on "Update" in the yellow bar. But there are none. I have also searched in the hidden sheets. There are none. But I keep getting "Update" in the top yellow bar. I do have links but to a single spreadsheet that is present in the same workbook I am working in. How do I get rid of the "Update" in the top yellow bar? or what other methods are available to search for external links?

12 Replies

@Lnjec Try the tool you'll find in the attached link.

https://manville.org.uk/software/findlink.htm 

@Riny_van_Eekelen Thank you for helping me. I have installed the add-in it now appears at the top left of the screen at the File command as "Find Links" with a magnifying glass. It started to work and gave me a very long list of cells that are all under a single column when I went there there were no links in those cells. But now when I click on the "Find Links" I get the following message.

Lnjec_0-1592217911790.png

This is also happening on another spreadsheet that I tried it on where I have the same problem with unidentified external links. But this time I go straight to receiving the above message without getting a list of cells that I got when I first ran "Find Links" on the previous spreadsheet.

 

@Lnjec Difficult to diagnose and/or duplicate the error without the file. I'm not a heavy user of the tool myself, but it has been recommended in this forum many times. Perhaps you can contact the authors directly from their web-site.

@Riny_van_Eekelen Thanks. I'm the author, can I send you the file?

@Lnjec I meant that you could perhaps contact the author of the tool, via their web-site. But feel free to send me the file. I can have a try.

Hi @Riny_van_Eekelen, I have attached a file with the problem. There is also another problem with this file which is a circular formula that I can not find.

@Lnjec 

Circular references are shown at the left of the status bar

image.png

Hi @Sergei Baklan Thank you I did not know the circular formulas cells were identified at the bottom of the spreadsheet, thanks.

@Lnjec 

As for the external link - it is in cell Wk06!AE5 in data validation.

image.png

and in other cells down (AE9, etc.). In attached file data validation is erased for this column.

@Sergei Baklan Thank you. I just selected the whole sheet and cleared all validations. Is it possible with the Excel available features to be able to find each cell individually with external Validation links?

@Lnjec 

Nope, that's third-party tools like FindLink. I've seen you tried it, don't know why it didn't help. In general it works:

image.png

@Sergei Baklan Maybe FindLink didn't work because I am working on Excel via VPN.