Excel link to sharepoint not working

Question

Hi All,

I've similar issue as those two topics, but no answer yet:
hyperlinks-between-excel-and-word-no-longer-exist.html

excel-hyperlinks-to-sharepoint-documents-not-worki.html

So what I'm trying to do is a link between an Excel file, to a Word file on Sharepoint.

Everything is working fine on my Excel file, I've my function containing this kind of link:
=Excel.Sheet.12|'https://XXX.sharepoint.com/compliance/Shared%20Documents/My%20File%20with%20space.docx'!'!_1708413787!Sheet1!R3C3'

But if I save this Excel file, close it, and re-open it. I've two popup

First:

This workbook contains links to one or more external sources that could be unsafe.

If you trust the links, update them to get the latest data. Otherwise, you can keep working with the data you have

[Update] [Don't Update] [Help]

and the second:

The workbook contains links to external data sources that use DDE (Dynamic Data Exchange) that may be unsafe and have been disabled. See File > Options > Trust Center for DDE configuration options

after those two popup, all my cells are in error with the message #REF! and if I've a lookup on the function, I can see the link has changed to:
=Excel.Sheet.12|'https://XXX.sharepoint.com/compliance/Shared Documents/My File with space.docx'!'!_1708413787!Sheet1!R3C3'

So every time I save and close the Excel file, all the %20 are replaced by a space char and the link doesn't work any more

Can anyone help me on that please ?

Thank you

Answer 1

Hi @NCLR ,
Please go to File- Options- Trust Center- Trust Center settings- External Content, please make sure you have enable/checked these options:

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @Emi Zhang-MSFT

Thx for your answer but unfortunately, it still replaces all my %20 with a space in the link.

So it still not works as expected

Do you have any other idea ?

thank you