Forum Discussion
SharePoint's Links don't work in Excel
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
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:
- Create a List of URLs:
- In one column, list all the SharePoint URLs you want to convert into hyperlinks.
- 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.
- 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.