This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have an Excel file at work that throws a security warning to enable content regarding updating links. Upon clicking the link, it prompts an error that Excel is "Unable to open http:// . The internet ..". I don't want anything linking out of the workbook, and I have already cleared the Name Manager so no names exist in the file. Moreover, went through the registry check but could not find the corresponding key mentioned in that article about proxies and external links. Any help would be much appreciated!
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Are there any hidden sheets? It may be on those.
Also, try this:
and this:
https://superuser.com/questions/938449/removing-phantom-external-links-in-excel
Nothing there either, searched through the workbook in formulas, values and comments with all various of URLs
You'll need to search each sheet for the text "http://" and remove any formulas that have that text in them. Check your headers and footers also. Those links can be sneaky and hide on you.
I searched through the file for any .xl through formulas and did not find anything either. I ran a compatibility check, which resulted in minor loss of fidelity issues related to "Some formulas in this workbook are linked to other workbooks that are closed. When these formulas are recalculated in earlier versions of Excel without opening the linked workbooks, characters beyond the 255-character limit cannot be returned. Location: Defined Names". There are no defined names in Name Manager either though..
You'll need to search through each worksheet in your workbook for that text of the web link. It's still there somewhere.