Show All

Save a Web query for use in other workbooks

Web queries are automatically saved for use in the current workbook. Saving a query in an .iqy file allows you to use it in a different workbook or share it with other users.

1. Point to Import External Data on the Data menu and click New Web Query for a new query or click Edit Query on the External Data toolbar for an existing query.

   If you're creating a new query, navigate to the page you want in the Address box, and click next to the tables you want to select. If there are no next to tables on the page, click Show Icons at the top of the dialog box to display them.

2. Click Save Query .
3. Locate the folder in which you want to save the query in the Save in box.
4. Enter a file name in the File name box.
5. Click Save.

   To run this query in other workbooks, click Import External Data on the Data menu, then click Import Data. Locate and open the .iqy file.