You will receive an Microsoft Excel Warning dialog box. This is because we changed the connection information. When we originally created the connection, it saved the information in an external .ODC file (ODBC Data Connection). The data in the workbook was the same as the .ODC file until we changed from a table command type to SQL command type in Step #6. The warning is telling you that the data is no longer in sync and the reference to the external file in the workbook will be removed. This is OK. Click Yes.
How to Configure Excel 2010 Pivot Table for Business Intelligence
From Tim Perdue, former About.com Guide
Previous
Next
- Final Result
- Insert Pivot Table
- Connect Pivot Table to SQL Server (or Other Database)
- Pivot Table Temporarily Connected to SQL Table
- Open Connection Properties
- Update Connection Properties With Query
- Receive Connection Warning
- Pivot Table Connected to SQL Server With Query
- Add Fields to Pivot Table
- Add Grouping for Date Fields
- Choose Grouping By Values
- Pivot Table Grouped by Years and Months
- Insert Slicer (New in Excel 2010)
- Pivot Table With User Friendly Slicers
- Choose Values From Slicers Which Updates Pivot Table
Excel 2010 Resources
See More About
Explore New Tech
- About.com
- Industry
- New Tech
- Training and Job Resources
- Tech Training
- Microsoft Excel 2010 - How to Configure Excel 2010 Pivot Table for Business Intelligence