Excel Web Access 报错:Unable to Display Named Item
The named item cannot be displayed.
The named item is either not available in the workbook or was not selected as a named item for viewing when the workbook was published. The named item may also be located in a hidden range of cells or in a collapsed outline.
根据提示,发现是在webpart设置中填写了错误的named Item字段导致,可以将该字段留为空白,如果非要填写名称,该名称必须在你引用的excel表格中存在。
Named Item的作用是为了只在excel web access中显示特定的内容,这些内容在excel中进行了命名;