Hi All.

I need some info on excel power query refresh. I have 14 power queries in one excel file. 1 sheet uses 10 pqs and I know the order in which I created them (some build upon the others). The 1st 3 of the 10 pull data from 3 different tables on an sql server and the rest modify / manipulate / merge / group / etc the data pulled... culminating in the final query (#10) that populates the excel sheet. I have a cmd button on the excel sheet and I want to refresh the data without vba "ActiveWorkbook.RefreshAll" - I dont want to refresh data that is used on other sheets - to save update time.

So.. Do I refresh the pqs in the order of creation (mimicking the dependencies)? Table 10 is based off table 9 (which is off table 5) and table 8 (which is off table 5) and table 7 (which is off 6 and ) and table 4 (off table 3) and table 2 (off 1).... (something like this)..

Or, can I refresh the 1st 3 sql server queries only and just the last one #10? Will refresh of #10 cause the predecesors to refresh also? Or do I need to refresh all in the order in which I created them (building in order)

Thanks
Steve
Harrisburg, PA