•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
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#Power Query
#SharePoint
#file paths
#Excel.Workbook
#File.Contents
#local network
#Excel
#source line
#file migration
#version update
#linking files
#data source
#document management
#data connection
#cloud storage
#team collaboration