Change the query for an external data range
- Click a cell in the external data range you want to change.
- Click Edit Query
on the External Data
toolbar.
Note For more information about constructing and editing queries in Microsoft Query, see Microsoft Query Help.