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 "groups" and would like to open a fresh "copy" of the worksheet each time the hyperlink is used so that each group can fill out their own worksheet from the same hyperlink. Is there a way to do this so that each group isn't accessing the same live document but various independent copies when they click the hyperlink?

 

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