Database Reference
In-Depth Information
Figure 4-22: The Connection Properties dialog box lets you configure the chosen data connection to
refresh automatically.
4. Choose a refresh rate:
Refresh Every X Minutes: Refresh the chosen data connection every specified number of
minutes. This refreshes all tables associated with that connection.
Refresh Data When Opening the File: Automatically refresh the chosen data connection
when the workbook is opened. This refreshes all tables associated with that connection
as soon as the workbook is opened.
5. Click OK when you're done.
Preventing Refresh All
In addition to the Refresh All command on the Ribbon, there are actually two more places you can
refresh your data in Excel 2013: the Ribbon's Data tab and the PivotTable's Analyze tab.
Clicking any Refresh All button anywhere in Excel essentially completely reloads Power Pivot,
refreshes all PivotTables, and updates all workbook data connections. If your Power Pivot Data Model
imports millions of lines of data from an external data source, you may want to avoid the processing
hit taken when clicking Refresh All.
In the Connection Properties dialog box (refer to Figure 4-22), deselect the Refresh This Connection
on Refresh All check box.
 
Search WWH ::




Custom Search