Before I wrote in for help, I have done REFRESH query and compare the EXCEL table to the online Bursa WEB page. They don't match. Previously I used to...
guanstan Today, 11:10 AMOK - 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 AMYes 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)...
The Web Query Table data in excel not the same as displayed online at the website.
That's impossible if you did the refresh correctly, I'm afraid, so it comes down to novice user error, one way or the other. Either way, you have learned...
AliGW Today, 11:17 AM