title	workbookApplication: calculate
description	Recalculate all currently opened workbooks in Excel.
ms.localizationpriority	medium
author	lumine2008
ms.subservice	excel
doc_type	apiPageType
ms.date	04/05/2024

workbookApplication: calculate

Namespace: microsoft.graph

[!INCLUDE beta-disclaimer]

Recalculate all currently opened workbooks in Excel.

[!INCLUDE national-cloud-support]

Permissions

Choose the permission or permissions marked as least privileged for this API. Use a higher privileged permission or permissions only if your app requires it. For details about delegated and application permissions, see Permission types. To learn more about these permissions, see the permissions reference.

[!INCLUDE permissions-table]

HTTP request

POST /me/drive/items/{id}/workbook/application/calculate
POST /me/drive/root:/{item-path}:/workbook/application/calculate

Request headers

Name	Description
Authorization	Bearer {token}. Required. Learn more about authentication and authorization.
Content-type	application/json. Required.

Request body

In the request body, provide a JSON object with the following parameters.

Parameter	Type	Description
calculationType	string	Specifies the calculation type to use. The possible values are: `Recalculate`, `Full`, `FullRebuild`.

Response

If successful, this method returns a 204 No Content response code. It doesn't return anything in the response body.

Example

Request

The following example forces a full calculation of the data and rebuilds the dependencies.

HTTP

POST https://graph.microsoft.com/beta/me/drive/items/{id}/workbook/application/calculate
Content-type: application/json

{
  "calculationType": "FullRebuild"
}