How to display Specific worksheet after publishing a workbook (selected entire workbook while publishing) RRS feed

  • Question

  • I have published a workbook by selecting entire workbook. Now i want to display 2 of 10 sheets from that workbook. That workbook even contains named items.
    • Changed type Mike Walsh FIN Friday, February 18, 2011 8:55 AM q
    • Moved by Mike Walsh FIN Friday, February 18, 2011 8:56 AM does not seem to be Excel Services. Is it even SharePoint? (From:SharePoint - Excel Services (pre-SharePoint 2010))
    Friday, February 18, 2011 3:18 AM

All replies

  • Hi, 

    Download that worksheet on your local machine and then open it.

    Now do following settings

    File > Publish > Excel services > Excel Service Option > Sheets

    Under drop down mark check boxes of required sheet and save it.

    Now upload that to site and in EWA web part provide item name (Sheet no.) to only show that checked sheets.

    Hope this helps.

    Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/
    Friday, February 18, 2011 9:34 AM
  • Hi Pratik,

    Thanks for d reply..

    But I want this to work even if I publish whole book. I hv mentioned the same thing in question also.Bcoz am using single workbook for many purposes I hv 2 publish entire workbook.





    Friday, February 25, 2011 4:52 AM