SharePoint's Links don't work in Excel

[Dvir_Gan-Or]

Hello everyone.

I'm having trouble with SharePoint links in Excel.

I have a Microsoft Form that asks the users to upload a file. When I export the comments of the form into Excel I get the SharePoint's URL of the files and they are not clickable.

When I try to make them HyperLinks I get the error below.

I would like to hear any thoughts or ideas please.

Thanks!

[#2]

@Dvir_Gan-Or 

The issue you are facing with SharePoint links not being clickable in Excel on Mac is likely due to how Excel on Mac handles links. Excel on Mac sometimes does not automatically recognize certain URLs as clickable links.

To make SharePoint links clickable in Excel on Mac, you can follow these steps:

1. Edit the URL Cells: Click on the cell containing the SharePoint URL. In the formula bar at the top, you should see the URL. Ensure that the URL is complete, including the "http://" or "https://" part. Edit the cell if necessary to include the full URL.
2. Use the "Hyperlink" Function: You can use the HYPERLINK function in Excel to create clickable links in cells. Here is how:
• In a different column, type the following formula where you want the clickable link to appear:

=HYPERLINK("https://your-sharepoint-url.com", "Click Here")

Replace "https://your-sharepoint-url.com" with the actual SharePoint URL you want to link to, and "Click Here" with the text you want to display as the clickable link.

1. Use "Insert Hyperlink" Option: Another way to create clickable links is by using the "Insert Hyperlink" option:
• Select the cell where you want the clickable link.
• Go to the "Insert" tab in the Excel ribbon.
• Choose "Hyperlink."
• In the "Link to" field, enter the SharePoint URL.
• Click "OK."

These steps should allow you to create clickable SharePoint links in your Excel on Mac document. Once set up correctly, you should be able to click on the link to open the SharePoint URL in a web browser.

My knowledge of this topic is limited, but since no one has answered it for at least one day or more, I entered your question in various AI. The text and the steps are the result of various AI's put together.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark them as helpful and like it!

This will help all forum participants.

[#3]

@NikolinoDE Thanks for the detailed answer!

For your solution I treid to use PC to overcome the problem. The thing is that when I act as you recommended it still doesn't work. I copied the link in the Excel to the Hyperlink box and applied, and the I tried the HYPERLINK Equation and the link still Doesn't work.

It is important to say that when I copy and paste the link to the URL box of my browser it work's completely fine!

Another question, If I have multiple links, is there any fast way to apply all the Hyperlinks?

Thank you!

Dvir

[#4]

@Dvir_Gan-Or 

If you have multiple links to convert into hyperlinks in Excel, you can use Excel's "HYPERLINK" formula along with the "Fill Handle" to apply them more efficiently. Here's how you can do it:

1. Create a List of URLs:
• In one column, list all the SharePoint URLs you want to convert into hyperlinks.
2. Use the HYPERLINK Formula:
• In an adjacent column, use the HYPERLINK formula to convert the URLs into clickable hyperlinks. Assuming your URLs are in column A, you can use the following formula in the adjacent column (let's say it's column B):

=HYPERLINK(A1, "Click Here")

This formula will create a clickable hyperlink in column B for the URL in the corresponding row of column A. The text "Click Here" will be displayed as the clickable link.

1. Copy the Formula Down:
• After entering the formula in the first cell of column B, use Excel's Fill Handle to copy the formula down to apply it to all the URLs in column A.
• Hover your cursor over the bottom-right corner of the first cell with the formula until it turns into a small black cross.
• Click and drag the Fill Handle down to cover all the cells with URLs in column A.

This process will quickly convert all your SharePoint URLs into clickable hyperlinks in the adjacent column. Each hyperlink will display "Click Here" as the clickable link text, but you can modify the text to something more meaningful for your data.

This method is efficient for converting multiple links into hyperlinks without needing to manually set up each hyperlink. It can save you time, especially if you have many links to convert.