Activate Power Pivot site collection features
Published: November 26, 2013
Summary: Activate Power Pivot Feature Integration for a site collection.
Applies to: SharePoint Server 2013 Enterprise
To enable Power Pivot functionality, such as scheduled data refresh, in a site collection, you must activate the Power Pivot site collection feature. You must be a site collection administrator to do this.
Be sure Power Pivot for SharePoint is configured on your farm before following this procedure.
To activate PowerPivot Feature Integration for Site Collections
Navigate to the site where you want to activate the Power Pivot site collection features.
Click Settings (), and then click Site settings.
Under Site Collection Administration, click Site collection features.
Click Activate for the PowerPivot Feature Integration for Site Collections feature.