Cannot press ENTER to expand or to collapse a PivotTable in an Excel workbook that is saved on a SharePoint site that is running Excel Services in SharePoint Server 2010

Article translations Article translations
Article ID: 982706 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

Consider the following scenario:
  • You edit an Excel workbook that is saved on a SharePoint site that is running Excel Services in Microsoft Office SharePoint Server 2010.
  • The workbook contains a PivotTable.
  • You press ENTER to expand the PivotTable, or you press ENTER to collapse the PivotTable.
In this scenario, the PivotTable does not expand or it does not collapse.

CAUSE

This behavior occurs because the keyboard shortcut to expand or to collapse a PivotTable is different in Excel Services in SharePoint Server 2010.

RESOLUTION

To expand a PivotTable in Excel Services in SharePoint Server 2010, press ALT+DOWNARROW.

To collapse a PivotTable in Excel Services in SharePoint Server 2010, press ALT+UPARROW.

Properties

Article ID: 982706 - Last Review: September 18, 2011 - Revision: 2.0
APPLIES TO
  • Microsoft SharePoint Server 2010
  • Microsoft Excel 2010
Keywords: 
kbtshoot kbexpertiseinter kbsurveynew kbprb KB982706

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com