How to disable warning in Excel while opening hyperlink

Question

Hello,

  Every time when User trying to open hyperlink located in Excel file below error message.

Hyperlink is pointing to PDF file located in user OneDrive.

Tried various solutions from google - without luck. Any advise?

Answer 1

Hi Marek1991,

I upload a PDF file into OneDrive and copy/paste the link into Excel workbook. After that, I can open that PDF file directly via clicking the link.

To disable “Hyperlinks can be harmful to your computer and data” when your user click the link of the file located on his OneDrive, I’d like to suggest you let your user add the URL of the file’s location into Excel’s Trusted Locations to see the outcome:

1. Copy the URL of OneDrive. (Https://tenant name-my.sharepoint.com)
2. Move to Excel>File>Options>Trust Center>Trusted Locations.
3. Check the option ”Allow Trusted Locations on my network (not recommended)”>Click OK.
4. Click Add new location>Paste the URL from step one.
5. Click OK, close all windows and reopen the workbook to see the outcome.

If you still meet the prompt info, to have a better understanding of your user's scenario and help him disable this prompt info, please share with me more info as below:

1. Detailed steps about how does your user get the link of the PDF file located on his OneDrive?
2. Where the workbook located?
3. Does your user meet security prompt info when he adds some links of other PDFs and other types of files?

Regards,

Neo

Answer 2

Dear Neo,

 I have tried suggested solution - without luck. Regarding your questions:

1. Detailed steps about how does your user get the link of the PDF file located on his OneDrive?

User is receiving package with .xlsm file and pdf files located next to it in folder. Inside of this excel file there are hyperlinks created with function =Hyperlink ( Exmaple: =HYPERLINK($AJ$7 & $AK$7 & "filename.pdf","91010")

2. Where the workbook located?

In OneDrive for Business folder: C:\Users<username>\OneDrive - Company name\

3. Does your user meet security prompt info when he adds some links of other PDFs and other types of files?

if excel file and pdfs are outside OneDrive folder - everything works fine.

Best Regards,

Marek

Answer 3

Hi Marek1991,

Thanks for your reply, to disable that prompt info, I'd like to refer suggestions in this thread. If this prompt info still exists, I'd like to suggest you check this article to disable this prompt info via Registry Editor.

WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Edit at your own risk. 

Please have a try and share with me your result.

Regards,

Neo

Answer 4

Hi Marek1991,

Does the hyperlink security prompt info still exist? Please post back if you still need any help.

Regards,

Neo

Answer 5

Hi Marek1991,

Does the hyperlink security prompt info still exist? Please post back if you still need any help.

Regards,

Neo

Hello Neo,

 I have checked mentioned solutions and did not work. ( I'm working  Windows10 Enterprise and Office 365 ). Any other idea?

Best Regards,

Marek