Forum Discussion
Formula for filename doesn't give local path to file in recent Excel release
Hi, using this to get path and filename (=LEFT(@CELL("filename",C10),FIND("[",@CELL("filename",C10))-1)) only returns a SharePoint web address when the file is opened locally on a synced SharePo...
Daniel, that can't be changed, if only Microsoft won't change the behaviour in one of new versions. For the files on synced with Sharepoint/Onedrive folders Excel returns web path. That's not only for the CELL(), everywhere. You may check, for example, File->Info->Copy path