Hi ChakradharY,
I am Vijay, an Independent Advisor. I am here to work with you on this problem.
Here is the response from Microsoft on this - https://excel.uservoice.com/forums/304933-excel...
You need to get from Data > External data > Use some Web Query to fetch this
Do let me know if you require any further help on this. Will be glad to help you.