How to display Specific worksheet after publishing a workbook (selected entire workbook while publishing)
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.
February 17th, 2011 10:23pm

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/
Free Windows Admin Tool Kit Click here and download it now
February 18th, 2011 4:40am

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. Thanks, Harish
February 24th, 2011 11:57pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics