How to Speed Up an ODC Connection in Excel 2007

1. Open the Microsoft Excel 2007 program on your computer and then click the 'Microsoft Office' button.
2. Click the 'Open' option and then select the Excel 2007 worksheet you want to speed up an ODC connection for. Click the 'Open' button.
3. Click the 'Data' tab from the top of the application and then click the 'Connections' option from the 'Connections' group.
4. Select the 'Usage' tab in the Workbook Connections dialog box. Click on each box in the 'Refresh control' section so that they're deselected.
5. Enter a lower number of records to retrieve in the 'Maximum number of records to retrieve' field.
6. Click the 'Definition' tab and then click the 'Parameter' button. You can then edit the parameters for your ODC query. For example, you can make your query as short as possible to speed up the connectivity.
7. Click the 'Apply' button to save all of your changes and then click the 'OK' button to close out of the dialog box.