Dynamic url of excel file opened in web browser

Help Something Else
,
1

Hi all,

I have a excel file saved in SharePoint,and I have attached that excel file link on email body. Once user recieve the mail, they will click on the link and the excel file will open in web browser and they will edit and save it on save path.

my problem is excel file link is not constant ,everytime the link is changing.

Ex: https://www.excel.com/folder/abc.xlsx?d=w1c1fdgjgsg=1web=Cbqgsv25R

In the above link the below part is common

“https://www.excel.com/folder/abc.xlsx?”

But

“d=w1c1fdgjgsg=1web=Cbqgsv25R”

This is changing everytime.

Is any way so that I can make this link as dynamic?

2

Hi @yashashwini2322 ,

Could you let us know how are you saving the Excel file in SharePoint ? What activities are you using currently ?

From this statement, are you mentioning that the same Excel file link gets changed or is it a different link for different Excel sheet ?

3

@yashashwini2322

even if you remove the value after ? it should still open

did you try that

also if it is more dynamic use a variable in the mail body to add the url everytime

cheers

4

Everytime when bot runs ,it will create a file in SharePoint with same file name.

5

If we remove after ? The file is opening but with read only permission,can not edit

6

@yashashwini2322

try adding ?mode=edit

cheers