Update data from WEB

K

Karthik

I've a data in WEB, which I want to update to an excel sheet daily, I
normally copy and paste the data into the spread sheet. Would it be possible
to somehow link the sheet to the web and update it daily automaticaly?

Thanks in advance...
 
K

Khoshravan

Are you familiar with following command?:
Data| Import External Data| New Web Query
This is a useful command for getting data from Web, esp. if during
copy/paste your data don't enter to independent cells automatically.
I think by this method, refreshing the sheet will update to new data
automatically. Please try and let us know, if it works, as you want.
 
Top