•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
What is the correct way to update power query filepaths in power query from local network to sharepoint?
We recently migrated all our files from a local network to sharepoint.
We have several files that we link to/ The Source line in PQ looks something like:
= Excel.Workbook(File.Contents(C:\workbook.xlsx"), null, true).
The same file is now on sharepoint. How do I update this Source line to go to the sharepoint version?
[link] [comments]
Want to read more?
Check out the full article on the original site