Excel Hyperlinks in Sharepoint

Question

We use an excel spreadsheet as our Diary document, that contains hyperlinks in cells that link to word documents

Once we put the spreadsheet onto sharepoint the hyperlinks no longer function.

Removing the link to re-add the hyperlink directing into the sharepoint spreadsheet version does not provide an option to enter a link to a document, only to either another place in the same document or to a URL location.

Is there anyway to add hyperlinks to other documents as you can when its not on sharepoint?

Answer 1

Hi Just-Training Info,

Glad to hear that my suggestion work for you.

I would like to summarize the information about this issue so that other community members can refer easily. 

Issue Description:  Link Excel worksheet to a Word document.

Environment: SharePoint Online.

Suggestion:

1. Upload Excel and Word document to SharePoint library.
2. Open Excel and choose content you want to insert hyperlink.
3. Go to Word document->Click …->Copy link.
4. Paste this link to Excel Edit hyperlink window. 

Additional Note: To better know about and use SharePoint Online. I want to share these articles with you, it may give some help.

What is SharePoint?

SharePoint Online Limits

Manage large lists and libraries in SharePoint

Thanks,

Ivy

Answer 2

Hi Just-Training Info,

Thanks for coming back and share resolve steps with us.

Since these links in Excel document can work normally, it’s not so much important to find the root cause that you can’t link it at first. Because it will use lots of time and experience and it need to check at the back-end.

About how to use SharePoint Online, I would like to share thisarticle with you. You can know about what’s SharePoint Online and how to use it. Hope it can bring more convenience to your work.

We appreciate your support and effort of our product. You’re welcome to post in our forum if you need any assistance and suggestion.

Best Regards,

Ivy