May 12 2020 02:17 PM
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 SharePoint.
It used to give me the local path which is needed in Power Query.
Why isn't this working anymore? It usually does, although it's a bit random at times. Reopening the file usually works in those cases.
But now it's always the SharePoint link.
How can this be changed?
Version is 2004 (Build 12730.20236)
Thanks
Daniel
May 13 2020 04:03 AM
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