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

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

sandy666

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

Watch MrExcel Video

Forum statistics

Threads
1,118,358
Messages
5,571,708
Members
412,413
Latest member
dvprajapati
Top