Yes you are right. I just started this week to use PowerQuery thru articles in the internet here and there. Anyway thanks for your help. I know next...
guanstan Today, 10:49 AMThat's because you haven't refreshed the query. I have opened both our workbooks and refreshed the queries. Mine now shows:
Excel 2016 (Windows)...
Your attached file (PQ Web Scrape AliGW.xlsx) No:1 Code: 0012 Name: 3A[s] Last Done: 0.74 Vol ('00): 2258
My attached file (50E.xlsx) ...
Is there a way to combine private sub with refreshing pivot fields?
Want to keep PivotFields("ABC") to always be selected as "True"....
The Web Query Table data in excel not the same as displayed online at the website.
OK - so you need to refresh queries! Either do this manually (Data ribbon - Refresh (All)), or right-click your query in the query bar on the right (Data...
AliGW Today, 10:53 AM