Click a cell in the region of the worksheet where your query data was returned (also known as an external data range).
Click Refresh Data 
on the External Data toolbar.
A spinning refresh icon 
appears in the
status bar to indicate that the query is running.
Double-click the icon to check the status of the query.
Tips
-
You can have your data refresh automatically when the file is opened, at timed intervals, or in the background by clicking Data Range Properties
on the External
Data toolbar
and selecting or clearing options under Refresh control.
- If the data returned to your worksheet after a refresh isn't what you expected, check the Web page you are querying to make sure it is in the same location and that the data on it is provided in the same way as when you created the query.