Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.
When you open a Microsoft Office Excel workbook in Excel Services, the workbook is displayed in one of two possible views:
Worksheet view In this view, you can display the workbook, including one or more worksheets, and all information on these worksheets. When a workbook is saved, the workbook author can specify whether all worksheets are displayed, or the author can select specific worksheets to display.
Named Item view In this view, you can only display one or more named items in the workbook. A named item can be one of the following: A chart, an Excel table, a PivotTable report, a PivotChart report, or a named range of cells.
What do you want to do?
Learn more about Named Item view
Named Item view is useful when you (a user or a workbook author) want to do the following:
-
Show only specific named items of a workbook, such as a chart or Excel table, because that's the only data that you want to view. For example as a workbook author, you may not want the user to view other parts of the workbook because the data is not necessary for a user to view them, or you want the data to remain hidden for security reasons. Or, you don't want a user to view the data behind a chart or PivotChart because there is not enough space for it in a Business Intelligence dashboard.
-
Select specific named items from the View drop-down list on the Excel Web Access toolbar to have more flexibility in displaying information in the workbook, instead of scrolling to find the information that you want, which may be cumbersome and time-consuming. As a workbook author, you can control how a user navigates the information in the workbook. In addition, Excel Services displays some named items in Named Item view differently from Worksheet view to minimize the need for navigation controls.
-
Connect Web Parts, such as the Filter Web Parts or List View Web Part, to Excel Web Access Web Parts, on a dashboard or on another Web Part Page. For example, you can use a selected value in a Filter Web Part to display a chart, an Excel table, and a named range, each in a separate Excel Web Access Web Part. For more information, see Connect Filter Web Parts to Excel Web Access.
You can view the following named items in Named Item view:
|
Named item |
Comments |
|
Excel Table |
|
|
Chart and PivotChart |
The entire chart or PivotChart is always displayed and never cropped, although horizontal and vertical scroll bars may be displayed. |
|
PivotTable report |
|
|
Named range |
The range must be contiguous and can be scoped either global or local to the worksheet (SheetName!RangeName). A named range is one that you define in Microsoft Office Excel 2007, or one that is defined by Office Excel 2007, such as a print area. A named range can also include other named items, charts, Excel tables, PivotTables, and PivotCharts. |
Notes:
-
When a workbook is saved in Named Item view, you can still view the Parameter Task Pane and set parameters, whether or not the named cell that corresponds to the parameter is contained in that named item. For example, you might want to display a chart, but allow a user to update the chart by entering a parameter value for a cell value that is not located that named item.
-
You can't switch to Worksheet view from Named Item view, or to Named Item view from Worksheet view in the same session.
-
The View drop-down list does not list individual worksheets.
Display a named item in Named Item view
There are two ways to display named items in Named Item view: Use the View drop-down list or set the Named Item to Display Drop-down List property.
Notes:
-
Named items are always listed in alphabetical order.
-
The View drop-down list is only displayed when the workbook author has selected one or more named items in the Excel Services Options dialog box before saving it, the Workbook Navigation, All Workbook Interactivity, and Named Item Drop-Down List properties are selected, and the Excel Web Access toolbar is displayed. For more information, see Excel Web Access Web Part custom properties and Microsoft Office Excel 2007 Help.
Use the View Drop-Down List
-
When Excel Web Access is in Named Item view, on the Excel Web Access toolbar, click the arrow next to the View drop-down list, and then select a named item.
Set the Named Item Drop-Down List property
A Web Part author can display a specific named item in Named Item view by setting the Named Item Drop-Down List property, for all named items specified by the workbook author in the Excel Services Options dialog box before saving the workbook. Setting this property is useful, for example, in a dashboard when you want to display a specific named item in the Excel Web Access Web Part, but you don't want the user to select other named items. For more information, see Excel Web Access Web Part custom properties.
Tip: A Web Part author may not be the same person as the workbook author or may not have access to the workbook. If you are not sure what named item to enter in the Named Item Drop-Down List property, either open the workbook in Excel 2007, and display the Excel Services Options dialog box to see a list of named items, or display the Excel Web Access Web Part with the Named Item to Display Drop-down List property cleared, and then note the named items from the View drop-down list.
Note: If you enter a value in the Named Item Drop-Down List property and the Excel Web Part is displayed in Named Item view, then this value is the default named item displayed.
Issue: The Named Item Drop-Down List property does not get cleared when I remove a List View Web Part Connection
When you connect a List View Web Part to the Excel Web Access Web Part by selecting the Provide Row To command on the List View Web Part's connection menu or the Get Named Object From command on the Excel Web Access Web Part's connection menu, the Named Item Drop-Down List property is also set to the connection value you pass. Later on, if you remove the Web Part connection, this value in the Named Item Drop-Down List property remains, and you may get a message alert stating that the named item cannot be displayed. To resolve this, clear the Named Item Drop-Down List property. For more information, see Excel Web Access Web Part custom properties.
