Page 660 - Excel 2013 All-in-One For Dummies

642 External Data Query
✦ Insert Slicer command button to create slicers for particular fields in the data list, that is, graphic objects that enable to you further filter your data. (See Book VII, Chapter 2.)
✦ Export command button to export the external data to a SharePoint list or a Visio diagram.
✦ Refresh command button to have Excel redo the query and automati- cally update the data table according to any changes made to the exter- nal database table(s).
✦ Properties command button to open the External Data Properties dialog box, where you can change formatting and layout options for the data retrieved in the worksheet.
✦ Open in Browser command button to open the external data as a table in your computer’s web browser.
✦ Unlink command button to sever a link between the data retrieved in the worksheet by the external query and its original data source on a server so that the data are no longer automatically kept up to date.