Excel: Power Query - How to Import the Most Recent File From a SharePoint Folder
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
Смотрите видео Excel: Power Query - How to Import the Most Recent File From a SharePoint Folder онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Mike Thomas 04 Август 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 69 раз и оно понравилось 2 людям.