How to combine (and debug) Excel files From SharePoint Folder

⏬ Click to check out the description for info and links⏬

Consolidate Multiple files From SharePoint Folder and how to debug and avoid errors

00:00 Intro
00:42 The Setup - Getting the correct folder path
01:54 Change SharePoint.Files to SharePoint.Contents
05:49 Adding new files (including problem files)
07:42 Identifying the problem files
11:15 Changing the Folder Path with the Split Out technique


Warning: to use SharePoint.Contents the user must hace access to to all levels of the SharePoint site.


The SharePoint.Contents method is the better approach for a quicker refresh, but you do need access to the Root SharePoint folder.


Sadly the button is not included in Excel 365 for Business .  However you can still use the code

= SharePoint.Contents("YOURPATH/", [ApiVersion = 15])


Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/


Connect with me
https://wyn.bio.link/
https://accessanalytic.com.au/