Installation

Preferred Windows 7 PC with .NET 4.0 full runtime, Microsoft Office Professional Plus 2010, Microsoft PowerPivot for Excel 2010 and Visual Studio 2010 to work with sample applications.

Downloads:

• Extract "Install.zip" contents to a temp folder, double click on "PivotDataWebSvcAddIn.vsto" to install.
• Sample Excel file "MyData.xlsx" with Pivot table data "MyData.zip"
• Sample .NET WinForms application using PivotData Web Service "PivotDataWin.zip"
• Sample ASP.NET WebForms application using PivotData Web Service "PivotDataWeb.zip"

Customize:

• Customize Excel Ribbon - enable Developer and Add-In Tabs.

Manage Add-Ins:

• Click on Developer Tab, "COM Add-Ins" icon to Enable/Disable/Remove Add-Ins.

Manage PivotData Web Service:

• Click on Add-Ins Tab, to manage PivotData Web Service. Click on the icons to start/stop the service.
• Click on "RetrieveUrl" icon to retrieve url's stored in Excel workbook subject property. Any changes to the url's are automatically saved to the workbook.

Configuring HTTP:

• Read more at http://msdn.microsoft.com/en-us/library/ms733768.aspx on configuring HTTP.
• Open new command prompt, runas administrator, type this at the command prompt
  "netsh http add urlacl url=http://localhost:8181/excel user=COMPNAME\USERNAME"
  replace "COMPNAME" with computer name and "USERNAME" with login name.