1. Industry
Send to a Friend via Email

Your suggestion is on its way!

An email with a link to:

http://newtech.about.com/od/tutorials/ss/How-To-Configure-Excel-2010-Pivot-Table-For-Business-Intelligence_7.htm

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

By

7 of 15

Receive Connection Warning
Photo © Microsoft

Click on Yes to Connection Warning

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.

  1. About.com
  2. Industry
  3. New Tech
  4. Training and Job Resources
  5. Tech Training
  6. Microsoft Excel 2010 - How to Configure Excel 2010 Pivot Table for Business Intelligence

©2014 About.com. All rights reserved.