Interested in becoming an Affiliate Trainer? We are now accepting applications for local and international positions. No need for cold calling! Receive referrals of people looking for specialized training in your area and get access to all of the training curriculum I have created and continue to create to use at your appointments.

Excel 2010 Data Tab

EXCEL 2010 DATA CONNECTIONS RIBBON

Connections

EXCEL 2010 DATA CONNECTIONS GROUP

The Connections section of the Data tab enables you to view and manage the data connections for your workbook.

Once your Excel workbook is open, select the Connections button in the Connections section of the Data tab. The Workbook Connections dialog box will open as shown in the image below. Here you can see all of the connections associated with your workbook.

To remove a connection, select it and click on Remove. If information has changed in your connection, select Refresh to have the information update in your Excel workbook.

EXCEL 2010 DATA CONNECTIONS WORKBOOK CONNECTIONS

To determine where your connection is used in your workbook, select your connection in the Workbook Connections dialog box and then click in the bottom box where it states, “Click here to see where the selected connections are used.” The location will appear in the box.

To manage or edit your connections, select a connection and then click on the Properties button. This will open the Properties dialog box. Here you can determine how you would like to refresh your data.

EXCEL 2010 DATA CONNECTIONS PROPERTIES





On the Definitions tab in the dialog box it will tell you more about the connection.

Locate the defaults and click on Cancel and close the Workbook Connections dialog box.

 

If you want to refresh as you are working in your file, you can select the Refresh All command in the Connections section of the Data tab. Again, this will update all of the information that is coming from a data source.

EXCEL 2010 DATA CONNECTIONS EXTERNAL DATA


To access the External Data Properties select the Properties command from the Connections section of the Data tab. The window to the right will open and you can choose from different data formatting and layout options. Select OK when you are finished.

Next Tutorial


This concludes the Connections tutorial.
Click next to continue to the Excel 2010 Sort & Filter tutorial.