Activate PowerPivot Feature Integration for Site Collections

Activating PowerPivot feature integration for specific site collections is required if you used the Existing Farm installation option to install SQL Server PowerPivot for SharePoint. If you installed PowerPivot for SharePoint using the New Server option, you can skip this task because SQL Server Setup already activated PowerPivot feature integration for the root site collection when it configured your deployment.

Feature activation at the site collection level is necessary to make application pages and templates available to your sites, including configuration pages for scheduled data refresh and application pages for PowerPivot Gallery and Data Feed libraries.

You must activate PowerPivot integration for each site collection that supports PowerPivot query processing.

Prerequisites

You must be a site collection administrator.

Activate PowerPivot Features

  1. On a SharePoint site, click Site Actions.

    By default, SharePoint web applications are accessed through port 80. This means that you can often access a SharePoint site by entering http://<computer name> to open the root site collection.

  2. Click Site Settings.

  3. In Site Collection Administration, click Site collection features.

  4. Scroll down the page until you find PowerPivot Integration Site Collection Feature.

  5. Click Activate.

  6. Repeat for additional site collections by opening each site and clicking Site Actions.