Hyperlink issue

[sadath]

Hi

i use this formula in my source file to open a target file (1-7Sales.xlsx) =HYPERLINK("C:\Users\sadat\Desktop\IBS DSR\1-7Sales.xlsx")
which is working fine as long as source file is in my local drive.

I moved my source file to one drive and tried the hyper link. it is not working
any idea

 

[GraH]

Maybe use the one drive path: see How to create a hyperlink to a onedrive file or folder without sharing it with anyone - and then use it