User Profile
G_Mack
Copper Contributor
Joined May 09, 2020
User Widgets
Recent Discussions
Re: Power Query Relative Path for OneDrive and Other Users
IMO, the developers could make it much easier for unsophisticated users like me by providing the option of relative query paths rather than absolute paths. I typically put the workbook and query data in the same folder and use simply use Excel to "Browse" to it. Excel then provides the correct absolute path to the data, So, if that folder is ever renamed, moved, or shared the query paths are no longer valid.36KViews0likes0CommentsRe: Power Query Relative Path for OneDrive and Other Users
SergeiBaklan Isn't the problem that Excel always wants to assign absolute addresses (file paths) to queries rather than providing the option of assigning relative paths? Relative paths would allow queries whose data resides in the same folder as the querying workbook to work even if the folder is renamed or moved.36KViews0likes2Comments
Recent Blog Articles
No content to show