PowerPivot: Other Excel addins may display an error message when PowerPivot is installed.


Summary



Symptoms


Excel addins that interact with PivotTables may not behave as intended when interacting with PivotTables based on PowerPivot data. The behaviors that may be exhibited by different Excel addins is specific to the implementation of the Excel addin and may include raising errors such as the following:

"Error loading cube metadata: A data source must be specified in the connection string"

More Information


Resolution


To work around this problem, users can either disable the PowerPivot addin in Excel 2010 or disable other addins that interact with Excel PivotTables. For resolution, users should contact support for the company which created the Excel addin.