问题描述
我正在设置SP 2013（Enterprise）安装，并创建了PowerPivot站点网站集。一切似乎都在工作 - 我将一个Excel文件上传到PowerPivot Gallery，这很好。它正确呈现显示图像。但是如果我尝试
打开Excel文件，我会收到错误：
I am setting up a SP 2013 (Enterprise) install, and created a PowerPivot Site Site Collection. Everything seems to be working - I upload one Excel file to the PowerPivot Gallery, and that is fine. It renders the display images correctly. But then if I try to open the Excel file, I get the error:
No Items to Show
We can't open this workbook. It's set to show only certain named items, but they aren't in the workbook.
You might want to contact the author for more information.
我试图"打开&维修与QUOT;我桌面上的Excel 2013中的.xlsx文件，然后重新上传，但这并没有解决问题。我尝试过的其他Excel文件没问题。这里有什么建议吗？
I tried to "Open & Repair" the .xlsx file in Excel 2013 on my desktop, and then re-upload, but that did not fix things. I have no problem with other Excel files I've tried. Any suggestions here?
推荐答案
请创建另一个简单的Excle进行测试，查看该问题是否仅适用于此特定Excel文件，然后检查 是否在Excel文件或SharPoint图库侧存在一些错误的配置，例如，如果每个命名项目都是
正确且现有。
Please create another simple Excle for testing, see if the issue only haapen to this particular Excel file, then check if there are some mis-configurationins in the Excel file or SharPoint gallery side, e.g. if each Named Item is correct and existing.
http://sharepointlogics.com/2012/05/excel-service-in-sharepoint-2010.html
谢谢
这篇关于PowerPivot Gallery“没有要显示的项目我们无法打开此工作簿。”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！