# SpreadsheetSetForceFormulaRecalculation

Sets whether formulas will be recalculated when the spreadsheet is opened

## Method Signature

```
SpreadsheetSetForceFormulaRecalculation()
```

### Arguments

No arguments.

## Examples

Force formula recalculation:

```js
// Force Excel to recalculate all formulas on open
var spreadsheet = SpreadsheetNew();
SpreadsheetSetForceFormulaRecalculation( spreadsheet, true );
```

## Related

* [SpreadsheetGetForceFormulaRecalculation()](https://boxlang.ortusbooks.com/boxlang-framework/boxlang-plus/modules/bx-spreadsheet/reference/built-in-functions/spreadsheetgetforceformularecalculation) - Get setting
* [SpreadsheetSetAutoCalculate()](https://boxlang.ortusbooks.com/boxlang-framework/boxlang-plus/modules/bx-spreadsheet/reference/built-in-functions/spreadsheetsetautocalculate) - Set auto-calc