User Profile
dannyg83
Copper Contributor
Joined May 12, 2020
User Widgets
Recent Discussions
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 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 Daniel2.7KViews0likes1Comment
Recent Blog Articles
No content to show