ExcelService.SetCalculationOptions Method

SharePoint 2010

Changes the calculation mode setting for workbooks.

Namespace:  Microsoft.Office.Excel.Server.WebServices
Assembly:  Microsoft.Office.Excel.Server.WebServices (in Microsoft.Office.Excel.Server.WebServices.dll)

<WebMethodAttribute> _
Public Sub SetCalculationOptions ( _
	sessionId As String, _
	calcType As WorkbookCalculation, _
	<OutAttribute> ByRef status As Status() _
Dim instance As ExcelService
Dim sessionId As String
Dim calcType As WorkbookCalculation
Dim status As Status()

instance.SetCalculationOptions(sessionId, _
	calcType, status)


Type: System.String

The Excel Web Services session ID.

Type: Microsoft.Office.Excel.Server.WebServices.WorkbookCalculation

The CalculationOptions type.

Type: []

Alert information.

The changes are temporary, that is, for the duration of the session. The changes are not saved even if the workbook is saved to its original or an alternate location. This method works in view and edit modes.

The calculation options you can use are Automatic, Semiautomatic and Manual. Automatic calculates workbook automatically. Semiautomatic calculates workbook automatically except for data tables. Manual disables automatic workbook calculation and requires an explicit call to one of the calculate methods to calculate: Calculate(String, String, RangeCoordinates, []),