Business intelligence with Excel Services 2013 - Business Intelligence in Microsoft SharePoint 2013 - page 169

Start the Excel client and open the workbook for which you want to enable data refresh on the
server. On the ribbon, click the Data tab. Then, in the Connections group, click the Connec-
tions button, as illustrated in Figure 6-7.

1.

FIGURE 6-7 The Connections option on Excel 2013 Data tab.

The Workbook Connections dialog box opens, as shown in Figure 6-8.

FIGURE 6-8 The Workbook Connections dialog box.

For each connection, you can select the connection and click the Properties button on the left,
which opens the Connection Properties dialog box, as illustrated in Figure 6-9.

2. In the Connection Properties dialog box, click the Definition tab.