Microsoft Office Tutorials and References
In Depth Information
Modifying web queries
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. However, financial data can change, so you should
use the buttons on the Data tab on the ribbon to change how
Excel deals with data drawn from other sources. One way that
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 Properties in the Connections group.
4 Select the Refresh Every check box.
5 Type the number of minutes between refreshes in the Minutes box.
6 Click OK.
TIP To have Excel refresh the data every time you open your
workbook, select the Refresh Data When Opening The File
check box.
Search JabSto ::

Custom Search