1 min readfrom 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?

submitted by /u/TigerUSF
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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