Monday, February 7, 2011

Unable to open Excel workbook as it does not contain any visible named items

Recently I setup the Excel Services on SharePoint 2010 Enterprise and posted an Excel workbook to the PowerPivot Gallery. But when I tried to open it on the portal, the following error displayed:
image
This is a very common error produced by Office Web Applications.  When saving an Excel workbook to a SharePoint site, you can decide to save the complete workbook or only specific Named Items (includes sheets, named cells or ranges, tables, PivotTables, or charts). This is different than saving the workbook to the file system.  By default the Named Items option are not enabled or needed in direct Excel interaction. However when you uploading the workbook to SharePoint, you must edit the Publish Option (to select the entire worksheet or Individual sheet) before you Save & Sent to the SP site.
There are two ways to edit the option as showing below:
image
 
image
Once you set the options, you should be able to view the published workbook on the SharePoint portal now.

3 comments:

  1. It is taken place in under a screen so that the viewers attention may increase in this respect.On the other hand they are very expert in what they re doing here and presenting to them.











    Netbooks

    ReplyDelete
  2. Fantastic goods from you, man. I have understand your stuff previous to and you are just too great. I actually like what you have acquired here, certainly like what you are stating and the way in which you say it. You make it entertaining and you still care for to keep it sensible. I can not wait to read much more from you. This is actually a great website.
    Graphics Cards

    ReplyDelete
  3. Hello There. I found your blog using msn. This is an extremely well written article. I will be sure to bookmark it and return to read more of your useful information. Thanks for the post. I’ll certainly comeback.
    excel vba courses london

    ReplyDelete