Update Files from SharePoint

ai1094

Board Regular
Joined
Aug 23, 2018
Messages
90
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?
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
7,397
maybe extract data directly to the main workbook and Append this
 

Watch MrExcel Video

Forum statistics

Threads
1,118,656
Messages
5,573,418
Members
412,529
Latest member
cTatch
Top