External Data Toolbar

Removed in 2007

alt text

alt textEdit Query - Displays the Query Wizard dialog box when Microsoft Query has bene used or the Edit OLE DB Query dialog box otherwise. This lets you to edit the SQL and change the query.
alt textData Range Properties - Displays the External Data Range Properties dialog box.
alt textQuery Parameters - Displays the Parameters dialog box. This is only available when the query has been created with query parameters using Microsoft Query.
alt textRefresh Data - Refreshes the data for the active query.
alt textCancel Refresh - This cancels a query.
alt textRefresh All - Refreshes the data for all the queries in the active workbook.
alt textRefresh Status - Displays the External Data Refresh Status dialog box. This is only available while a query is being refreshed.

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext