Forum Discussion
Update Links Window
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.
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.
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.
