Hi, I just started using the Power Query add-on for Excel. I have a workbook that is connected to 3 different excel workbooks. The 3 workbooks were extracted from the SharePoint site and put into a folder. I have the main workbook which appended those 3 workbooks into 1 sheet. My problem is that my main workbook doesn't add the new rows of data when I refresh it, however, if I open all 3 workbooks and refresh them, the new rows of data is shown. When I save and close the 3 files, my main workbook will then finally recognize the new data and update.
My question: Is there a way to refresh all 3 workbooks that are appended in my main workbook without having to open them each up individually and refreshing them myself?
My question: Is there a way to refresh all 3 workbooks that are appended in my main workbook without having to open them each up individually and refreshing them myself?
