In this video I show how to use Power Query in Excel to import data from a single file stored in a SharePoint folder. The data is imported from the file with the most recent Modified Date. Great for weekly or monthly reporting where the filename is different and you can't or don't want to rename it.
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #sharepoint #powerquery #latestfile