Link an Excel table to an external (web) data source

[rjmccafferty1]

Is there a way to link an excel table to an external data source?

The is a set of government data that is published periodically that we use. Ideally, we would to link a spreadsheet to that data and have it refresh automatically, or to refresh when we ask it to. Either way would be fine and much nicer that going through the whole open the web page and go through the copy and paste routine.

The external data source is completely consistent in their layout.

 

[SkipVought]

Hi,

Data > Imort External data > New Web Query

Once you have the data linked, all you need do is Data > Refresh

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]