![]() Next run the ShowAllNames VBA script from the comment above Follow the steps in this link (including the VBA steps)Ģ. There are other settings in the trust center that may be worth playing with including ActiveX Settings for All Office Applicationsġ. In my situation, when I Enabled All Macros, it revealed several linked files that I was completely unaware of. Depending on the level of severity of the number of hidden links in your file, I wouldn't "Enable All Macros" unless you were at wits end. Just a final follow-up note for anyone that comes searching for a solution to find and break hidden excel links based upon my research:Ġ. The links identified in Data > Edit Links are all valid. ![]() So back to my original question: how do I find and remove Active Content links given all of the steps I have take above?ĮDIT: I have existing links in the file that must remain intact. So I am now trying to clean up my file to get rid of these hidden Active Content links This all started because I was copying data or importing tabs from other excel spreadsheets into my spreadsheet. How to find links in Excel and break external links. I have followed most of the steps on this page. My file has some minor macros but I have gone through every line of the code and it does not have links or references to. With regards to the File > Options > Trust Centre > Active X Settings, I can change the Active X settings to "disable all control without notification" but that does not solve my problem of finding and removing the does not appear as a link. So my problem is #2 above: how do I find where and remove the link is because its not in Data > Edit Links, Data > Queries & Connections, Formulas > Name Manager, Control G > Object search, Control F search for across the workbook and its not an external link in a chart, pivot table, or macro. Tell us the account you want to use to open - random name of file to illustrate my problem. When I click, excel proceeds to try and access files 1) linked files available on my network but have been moved and 2) MS 365 login dialog box opens and requests: Sign In. ![]() ![]() SECURITY WARNING: Some active content has been disabled. When I open my excel file (using Office 365) I get this security message:
0 Comments
Leave a Reply. |