2.2.5.17 ExcelServicesViewOptions

Namespace: http://www.microsoft.com/performancepoint/scorecards

The ExcelServicesViewOptions simple type specifies how a user is allowed to interact with an Excel Services report ([MS-ESP]).

 <xs:simpleType name="ExcelServicesViewOptions" xmlns:xs="http://www.w3.org/2001/XMLSchema">
   <xs:list>
     <xs:simpleType>
       <xs:restriction base="xs:string">
         <xs:enumeration value="AllowInteractivity"/>
         <xs:enumeration value="AllowParameterModification"/>
         <xs:enumeration value="ShowWorkbookParameters"/>
         <xs:enumeration value="AllowSorting"/>
         <xs:enumeration value="AllowFiltering"/>
         <xs:enumeration value="AllowHyperlinks"/>
         <xs:enumeration value="AllowPivotSpecificOperations"/>
         <xs:enumeration value="AllowPeriodicRefresh"/>
         <xs:enumeration value="CloseWorkbookSessions"/>
         <xs:enumeration value="AllowScratchPadMode"/>
       </xs:restriction>
     </xs:simpleType>
   </xs:list>
 </xs:simpleType>

The following table specifies the allowable values for the ExcelServicesViewOptions simple type.

Value	Meaning
AllowInteractivity	Allows users to interact with the workbook.
AllowParameterModification	Allows users to change workbook parameters.
ShowWorkbookParameters	Allows users to view and edit workbook parameters.
AllowSorting	Allows users to sort when using AutoFilter, lists (1), and PivotTables.
AllowFiltering	Allows users to filter when using AutoFilter, lists (1), and PivotTables.
AllowHyperlinks	Allows users to use hyperlinks in the workbook.
AllowPivotSpecificOperations	Allows users to drilldown, find members (2), and take actions in PivotTables in the workbook.
AllowPeriodicRefresh	Allows Excel Services to perform periodic refreshes of external data sources if the data connection has a refresh interval defined.
CloseWorkbookSessions	Closes the current workbook before opening a new one.
AllowScratchPadMode	The value of this element MUST be ignored.