Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2282155%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2282155%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20one%20formula%20in%20excel%20but%20facing%20one%20issue%3C%2FP%3E%3CP%3Eformula%20is%20%3DCELL(%22filename%22)%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3Eand%20result%20is%20showing%20like%20https%3A%2F%2Fd.docs.live.net%2F1cdad3c%26nbsp%3B.......%3C%2FP%3E%3CP%3Ebut%20it%20should%20show%20local%20path%20only%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2282155%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2283089%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2283089%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1034528%22%20target%3D%22_blank%22%3E%40pranav_cpd%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20local%20folder%20is%20synced%20with%20OneDrive%2FSharePoint%20path%20shows%20URL%20of%20the%20file%20on%20above%20location%2C%20not%20path%20of%20the%20local%20synced%20folder.%20That%20how%20it%20works.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2282348%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2282348%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1034528%22%20target%3D%22_blank%22%3E%40pranav_cpd%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUp%20to%20now%2C%20I%20have%20accompanied%20or%20supported%20mail%20around%201770.%20Over%20half%20the%20post%20was%20just%20like%20this%20one.%3C%2FP%3E%3CP%3EIf%20I%20can%20recommend%20you%2C%20add%20a%20file%20(with%20no%20sensitive%20data).%20Describe%20your%20request%20in%20detail%20based%20on%20this%20file.%3C%2FP%3E%3CP%3EIn%20this%20way%2C%20both%20sides%20have%20a%20profit%3B%20they%20get%20a%20solution%20proposal%20much%20faster%20and%20more%20precisely.%20Those%20who%20want%20to%20help%20have%20a%20basis%20with%20which%20they%20can%20propose%20a%20solution%20with%20less%20investment%20of%20time.%20Why%20does%20the%20help%20also%20want%20to%20do%20the%20preparatory%20work%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%20Of%20course%2C%20knowledge%20of%20the%20Excel%20version%20and%20the%20operating%20system%20plays%20a%20major%20role%20in%20most%20cases.%3C%2FP%3E%3CP%3EWhat%20did%20you%20send...%20to%20help%20us%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20read%20this%20Link%20for%20detail%20Information%3A%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_self%22%3EWelcome%20to%20your%20Excel%20discussion%20space!%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20end%2C%20I%20ask%20myself%2C%20How%20many%20additional%20users%20would%20it%20be%20helped%20if%20this%20time%20was%20saved%20from%20the%20start%3F...%20Does%20not%20we%20harm%20our%20next%20one%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20thank%20you%20for%20your%20time%2C%20patience%20and%20understanding.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am using one formula in excel but facing one issue

formula is =CELL("filename")

and result is showing like https://d.docs.live.net/1cdad3c .......

but it should show local path only

 

1 Reply

@pranav_cpd 

If local folder is synced with OneDrive/SharePoint path shows URL of the file on above location, not path of the local synced folder. That how it works.