1. Industry
Send to a Friend via Email

Your suggestion is on its way!

An email with a link to:


was emailed to:

Thanks for sharing About.com with others!

You can opt-out at any time. Please refer to our privacy policy for contact information.

How to Configure Excel 2010 Pivot Table for Business Intelligence


5 of 15

Open Connection Properties
Photo © Microsoft

Open Connection Properties form.

Before we start choosing data for the PivotTable, we need to change the connection to the SQL query. Make sure you are on the Options tab and click on Change Data Source drop down from the Data section. Choose Connection Properties.

This brings up the Connection Properties form. Click on the Definition tab. This shows you the connection information for the current connection to SQL Server. While it references a connection file, the data is actually embedded in the spreadsheet.

©2014 About.com. All rights reserved.