Hyperlink - Functionality lost when sheet saved as new workbook

[Nutters_Inc]

Hyperlinks are clearly not working for me, looking for some direction.

I have an Excel tracker I use for material purchases.

The file has headers of key dates of events, some are document names. Each row relates to a individual material request.

To track all documents, I have created hyperlink to SharePoint (that act as repository for the document storage.)

This gives me a one stop solution for tracking all requests.

Some of this information is sensitive, while others would be suitable for general use.

The information now available is empowering staff to improve efficiencies by tracking live progress of materials and aligning these up to labour required to use the materials.

This is new tracker for the business and I’m starting to feel the pain of getting too many requests for updates.

What I would like to do is to pull out a simplified set of the date, void of the sensitive details and make available for all. For this to be self-refreshing and therefore linked to live details. End users still need to be able to search and/or re-sort the data to meet their requirements.

Such a simple process. All working fine. My stumbling issues is around the hyperlinks. Can not find a solution that maintains them.

Having looked online for a solution, clearly, I'm not able to ask the right question, as all answers found so far are not able to give me a solution for how to code the hyperlinks from details held within another workbook. Think I'm missing something basic but vital. Would appreciate anyone suggestions of a fix.
Stay safe.

 

[Nutters_Inc]

sorry typo

Thanks for the reply. In OrderRequests!AA51 is a date, with a hyperlink to the delivery document.
Yes I have used a UDF, as below.
Function GetURL(cell As Range) As String
GetURL = cell.Hyperlinks(1).Address
End Function
Am using Microsoft365

Function URL(cell As Range) As String
URL = cell.Hyperlinks(1).Address
End Function

 

[felixstraube]

can you show us the content of OrderRequests!AA51. Painting over the sensitive information.
And show us what does your Url UDF return?