Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 928739 - Last Review: May 14, 2007 - Revision: 1.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
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.
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.
This behavior is by design.
APPLIES TO
- Microsoft Office Excel 2007
- Microsoft Office SharePoint Server 2007
| kbprb kbnetwork kbtable kbdataaccess kbpivottable kbtshoot kbexpertiseinter KB928739 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate