Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. The "Get Filter Values From" command is not displayed in the Connections menu when you try to edit an Excel Web Access Web Part in Excel Services

The "Get Filter Values From" command is not displayed in the Connections menu when you try to edit an Excel Web Access Web Part in Excel Services

View products that this article applies to.

Symptoms

When you try to edit an Excel Web Access Web Part in Excel Services, the Get Filter Values From command is not displayed in the Connections menu. This behavior occurs if the following conditions are true:
  • The Web Part is located on a page that contains any SharePoint filter.
  • The Web Part loads a Microsoft Office Excel 2007 PivotTable workbook from any location other than from a Windows SharePoint Services 3.0 document library. For example, when you try to edit the workbook from a page that contains a choice filter (Authored list filter), the Get Filter Values From command does not appear.
Note Excel Services is included in Microsoft Office SharePoint Server 2007.

↑ Back to the top

Cause

This behavior occurs because of any of the following reasons:
  • No single-cell parameters exist in the workbook.
  • Only PivotTable report filter parameters exist in the workbook.
  • Parameter Modification is disabled in the Excel Web Access Web Part properties.
  • The workbook is stored in a Universal Naming Convention (UNC) or HTTP path.

    Note The Excel workbook must be stored in a Windows SharePoint Services 3.0 document library.

↑ Back to the top

Status

This behavior is by design.

↑ Back to the top

Keywords: KB928739, kbexpertiseinter, kbtshoot, kbpivottable, kbdataaccess, kbtable, kbnetwork, kbprb, kbarchive, kbnosurvey

↑ Back to the top

Article Info
Article ID : 928739
Revision : 3
Created on : 1/16/2015
Published on : 1/16/2015
Exists online : False
Views : 288