Named Items Named Items is a feature of Excel which allows Naming few cell area. This makes us easier to integrate the Excel workbook with SharePoint pages. We can show different areas of the same sheet or different sheet in multiple Excel Web Access web parts. Create Excel Workbooks Create an Excel workbook with 2 charts as in the following, Now select the cells for Chart1 and right click to get the following menu. You will get the Name dialog box as shown below. Enter a name Chart1 without spaces. Now repeat the same for Chart2 area. SharePoint Upload the above workbook to SharePoint document library. Create a new page using the Add Page menu item. Insert two Excel Web Access web parts into the page. For the first web part:
Now go to the second web part & repeat for Chart2 named item. Save the page & you can see as shown below. You can see that different parts of the sheet are displayed here. Note: Named Items can be used to display information from multiple sheets too. References
Summary In this article we explored how to use Named Items in Excel Web Access web part.
You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$20
For Premium members:
$45
For Elite members: