Microsoft® Office Excel® 2007 Plain & Simple

Modifying Web Queries

When you create a Web query, you make it possible to use data from tables on your company’s intranet or the Internet in your worksheets. Financial data can change, though, so you should use the buttons on the Data tab of the ribbon to change how Excel deals with data drawn from other sources. One way you can ensure that the external data is current is to have Excel refresh the data regularly.

Schedule Web Query Data Refreshes

1. Click the Data tab.

2. Click any cell that contains query data.

3. Click the Properties button in the Connections ...