Sharepoint Excel Services does not seem to support protected Sheets. Is there any other way to make some sheets read-only and make it work in Excel Services?
A:
Expose the values you need as references in another sheet. Publish the other sheet in place of the protected one.
Øyvind Skaar
2009-01-11 13:46:06
Thanks for your response.I have tried your sugestion, but still the error arrise while opening the excel in excel services "Some of the sheet's protected"
guna Samba
2009-01-12 06:30:04
How do you plan to expose the workbook in Excel Services to the users?
Øyvind Skaar
2009-01-12 18:16:11