Name two ways in which Excel automatically refreshes a connection.
One of the ways that Excel automatically refreshes a connection is when you open the workbook. The other way is at regular intervals. This is activated when you select the Refresh every check box from Usage tab under Connection Properties. You will also be required to set the number of minutes when it should refresh. You can read more about it at http://office.microsoft.com/en-001/excel-help/refresh-connected-imported-data-HP010087045.aspx#BMautomatically_refresh_data_when_a_wor.