Forum Discussion

johngallagher's avatar
johngallagher
Copper Contributor
Sep 20, 2023

Hyperlink an excel cell to a word document in sharepoint as a new copy each time.

  Hello,   I am building a master excel sheet and am planning to link to individual word worksheets within sharepoint from different worksheet cells. I am going to distribute this to multiple "gro...
App
files
onedrive
SvenSieverding's avatar
SvenSieverding
Bronze Contributor
Sep 21, 2023

Hi johngallagher ,

you could create a new page and add a button to it.

Create the button url like this

https://<mytenant>.sharepoint.com/sites/<mysite>/_layouts/download.aspx?SourceUrl=<link to file>

so for example

https://tenant.sharepoint.com/sites/mysite/_layouts/download.aspx?SourceUrl=https://tenant.sharepoint.com/sites/mysite/Documents/MyReport.xlsx


You will get something like this:

If you press the button, your Excel File will be downloaded by the user and not opened directly.

Best Regards,
Sven

Resources