Article ID: 2022522 - Last Review: June 12, 2010 - Revision: 1.0

You cannot add a new Slicer to your PowerPivot workbook

View products that this article applies to.
System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
Expand all | Collapse all

Symptoms

Consider the following scenario:

  • You open a workbook that contains Microsoft PowerPivot data.
  • You try to add a Slicer to a PivotTable by using the PowerPivot field list.

In this scenario, you may receive the following error message:

============================
Error Message:
============================
The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG))
----------------------------
Slicer Field could not be added. Reason: The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG))
Back to the top

Cause

The PivotTable is not in sync with the PowerPivot data. To verify this, try to add a Slicer by using Microsoft Excel’s native support for adding Slicers, instead of by using PowerPivot functionality. In this case, you receive the following error message:

This PivotTable report is invalid. Try refreshing the data (On the Options tab, click Refresh). 

Back to the top

Resolution

Refresh the table data by using the Refresh option under Options. Or, click Refresh from the shortcut menu on the PivotTable. Then, try again to add the Slicer.
Back to the top
APPLIES TO
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
Back to the top
Keywords: 
KB2022522
Back to the top