Ya you can ...

I have Ms office 2007 so pls follow this steps..

MS Excel > Data > Get External data > from web > paste your located link on that Box and all the data linked with your Excel sheet..

Thanks for reply...but its not working....its not loading the whole table but only the first line....

hi

pl refer this link:

https://www.get-digital-help.com/2011/07/08/excel-udf-import-historical-stock-prices-from-yahoo/

Thanks//Vaibhav