本文介绍了ExcelWebAccess出现“UnabletoDisplayNamedItem”错误的原因及解决方案。此问题通常源于WebPart设置中指定的namedItem字段与实际Excel文件中定义的不匹配。文章指导如何正确配置以确保仅展示所需内容。
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中进行了命名；
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
