Saturday, March 28, 2009

SharePoint Excel Services – Session Management

A session will be generated whenever a user views a workbook in browser using Excel Services. The session settings for excel services can be configured in SSP. To configure these settings, navigate to SSP site and click on “Edit Excel Services Settings” from “Excel Services Settings” section.



The default session per user is 25. You can even use “STSADM” command line utility to configure the Excel Services Session management setting.

STSADM.EXE –o set-ecssessionmanagement –ssp mysharedservice
-maxsessionperuser 40

This will increase the session per user to 40.

Friday, March 27, 2009

Excel Web Access - Unable to Load Workbook

The Excel web access will throw the following error when the associated workbook is created using Office Excel 2003 / lower.


Error:
The workbook that you selected cannot be opened.
The workbook may be in an unsupported file format, or it may be corrupt.








Use Office Excel 2007 to create the workbook and save it to your library (trusted location) and now the Excel Web Access web part will display the workbook.