Forum Discussion
Advanced Threat Protection - Safe Links
- Feb 28, 2023
I thought I would update everyone from my post prior.
I engaged the help of two of our top IT experts at my company. They talked with other "experts" and in the end they came back with....."Sorry, but we cannot figure this one out."
The odd thing is that this does NOT affect other MS programs or apps. I have tested this over and over and it works just fine in Word, Publisher, or even PowerPoint. No problem opening up an active hyperlink. Heck, I can even print my SPREASHEET in Excel over to an Adobe PDF and guess what? That opens flawlessly without the delays! No errors.
This is ONLY happening in Excel and ONLY since that last big update they had for Office 365.
I am learning to just live with it and hope that one day down the road MS figures this out and does fix it. But when all these big shots and experts with Microsoft and Excel specifically.....can't figure this out? I don't have a lot of hope left on this fix. But I sure wish someone from MS would pay attention to this and figure it out.
Mark
First of all, it looks as if there might be an error in the URL in the image. It currently reads "https://soundcloud.com/ouncil1archive......." and I wonder if it shouldn't be "https://soundcloud.com/council1archive......." such that the "error" referred to is simply that it's an invalid URL.
Second, though, do you actually need the hyperlinks to be "active" hyperlinks? Surely you're not always clicking on all of them? If I were in your position, I can see storing the URL for a site, but doing it as a bit of text that can be activated when needed, but otherwise just stored as text. For example, here's a hyperlink in Excel to the page that we're on.
But you can right click on that cell containing an active hyperlink and select "Remove hyperlink" to end with
To remove the active hyperlink just enter a cell that contains it and click on "Remove hyperlink" in this dialog box
- OllyhalNov 09, 2022Copper Contributor
I have exactly the same error. And no: it does not help to ask whether these links have to be active or not.
It´s a malfunction and I want to know why this is not working.
It´s very annoying: in my case I keep track of vinyl releases with the according link to discogs.
- mathetesNov 09, 2022Silver Contributor
I have exactly the same error. And no: it does not help to ask whether these links have to be active or not.
It may not have helped you. May not even have helped the original poster. It still is a reasonable question to ask, in that it points to what could be (in some instances) a reasonable resolution.
It´s a malfunction and I want to know why this is not working.
And that's a reasonable desire. I'm not the one to ask it of, however. I recommend starting a new thread so that it might attract the attention of a Microsoft tech expert with experience debugging hyperlinks.
- Therrion71Aug 09, 2022Copper ContributorThe spreadsheet the I continually update is an indexed archive of all the broadcast with all the links to each broadcast embedded into the title of the broadcast in SoundCloud. There is a host of people that are constantly reviewing the archives and updating the web addresses to match the title of the archive. This index of archives go all the way back to 2014. As the people that go through the archives and update the titles and web addresses, they do so at a month at a time. When they are done with all their changes they let me know so I can update the spreadsheet and post it to our community. It is a labor of love to say the least. The spreadsheet is made available in excel and pdf format so people of CoT (Council of Time) can quickly find the archive they wish to listen to, click the link and be immediately taken to the broadcast of their choosing. So, long story short is yes I do click on each link to verify that the link is still valid and if it’s not I update it so that it is. This added step of validation error is an unwanted nuisance to say the least and I would like to disable this functionality of Advanced Threat Protection - Safe Links. Any help in this is much appreciate because I update this every week.