Part V: Understanding Power Pivot and Power Query
Click Connections at the top of the task pane and then double-click the connection with
which you want to work.
With the Connection Properties dialog box open (see Figure 35.23), select the Usage tab.
Here you’ll find the following options:
Refresh Every X Minutes Placing a check mark next to this option tells Excel to refresh
the chosen data connection automatically after a specified number of minutes. This will
refresh all tables associated with that connection.
Refresh data when opening the file Placing a check mark next to this option tells Excel
to refresh the chosen data connection automatically upon opening the workbook. This will
refresh all tables associated with that connection as soon as the workbook is opened.
Refresh this connection on Refresh All Earlier in this section, you discovered that you can
refresh all the connections that feed Power Pivot by using the Refresh All command found on
the Power Pivot Home tab. If the data connection in question imports millions of lines of data
from an external data source, you may not want to slow down your machine each time you
trigger a Refresh All. You can remove the check mark next to the Refresh This Connection on
Refresh All option. This essentially tells the connection to ignore the Refresh All command.
FIGURE 35.23
The Connection Properties dialog box lets you configure the chosen data connection to
refresh automatically.
