Jun 14 2020 05:41 AM
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?
Jun 14 2020 07:58 AM
@Lnjec Try the tool you'll find in the attached link.
Jun 15 2020 03:50 AM
@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.
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.
Jun 15 2020 09:44 PM
@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.
Jun 16 2020 03:39 AM
@Riny_van_Eekelen Thanks. I'm the author, can I send you the file?
Jun 16 2020 05:02 AM
@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.
Jun 22 2020 07:41 AM
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.
Jun 22 2020 07:48 AM
Jun 22 2020 08:02 AM
Hi @Sergei Baklan Thank you I did not know the circular formulas cells were identified at the bottom of the spreadsheet, thanks.
Jun 22 2020 09:23 AM
As for the external link - it is in cell Wk06!AE5 in data validation.
and in other cells down (AE9, etc.). In attached file data validation is erased for this column.
Jun 22 2020 11:41 AM
@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?
Jun 22 2020 01:18 PM
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:
Jun 22 2020 02:42 PM
@Sergei Baklan Maybe FindLink didn't work because I am working on Excel via VPN.