XL.Book.Release
---------------

Frees a workbook from memory.

| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
|---|---|---|---|---|---|---|
| [XL](component_XL.md) | [3.5](newinversion35.md) | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |

MBS( "XL.Book.Release"; BookRef ) 

**MBS**( **"XL.Book.Release";** /\* Frees a workbook from memory. \*/  
**$BookRef**) /\* The reference to the Workbook you want to release.e.g. $ref \*/ 

### Parameters

| Parameter | Description | Example |
|---|---|---|
| BookRef | The reference to the Workbook you want to release. | $ref |

### Result

Returns OK on success.

### Description

Frees a workbook from memory.  
You need to call this method when you are done with a workbook in order to prevent out of memory situations.  
### See also

- [WebHook.Release](WebHookRelease.md)
- [XL.Font.SetColor](XLFontSetColor.md)
- [XL.Format.SetWrap](XLFormatSetWrap.md)
- [XL.List](XLList.md)
- [XL.LoadBook](XLLoadBook.md)
- [XL.Sheet.CellType](XLSheetCellType.md)
- [XL.Sheet.CellWriteFormula](XLSheetCellWriteFormula.md)
- [XL.Sheet.CellWriteText](XLSheetCellWriteText.md)
- [XL.Sheet.RemoveRow](XLSheetRemoveRow.md)
- [XL.Sheet.SetCol](XLSheetSetCol.md)

### Release notes

- **Version 10.0**
    - Added [XL.Book.ReleaseAll](https://www.mbsplugins.eu/XLBookReleaseAll.shtml) function.

### Example Databases

- [XL/AutoFilter](https://www.mbsplugins.eu/MBS-FileMaker-Plugin-Examples/XL/AutoFilter.shtml#1ScriptAnchor_)
- [XL/Change Column Names](https://www.mbsplugins.eu/MBS-FileMaker-Plugin-Examples/XL/Change%20Column%20Names.shtml#4ScriptAnchor_)
- [XL/Conditional Formatting](https://www.mbsplugins.eu/MBS-FileMaker-Plugin-Examples/XL/Conditional%20Formatting.shtml#1ScriptAnchor_)
- [XL/Converter](https://www.mbsplugins.eu/MBS-FileMaker-Plugin-Examples/XL/Converter.shtml#1ScriptAnchor_)
- [XL/Edit Sheet](https://www.mbsplugins.eu/MBS-FileMaker-Plugin-Examples/XL/Edit%20Sheet.shtml#1ScriptAnchor_)
- [XL/Export records](https://www.mbsplugins.eu/MBS-FileMaker-Plugin-Examples/XL/Export%20records.shtml#2ScriptAnchor_)
- [XL/Writing data](https://www.mbsplugins.eu/MBS-FileMaker-Plugin-Examples/XL/Writing%20data.shtml#1ScriptAnchor_)
- [XL/XL Import and Export](https://www.mbsplugins.eu/MBS-FileMaker-Plugin-Examples/XL/XL%20Import%20and%20Export.shtml#2ScriptAnchor_)
- [XL/XL Test](https://www.mbsplugins.eu/MBS-FileMaker-Plugin-Examples/XL/XL%20Test.shtml#1ScriptAnchor_)

### Blog Entries

- [MBS Plugin Advent calendar: 13 - XL](https://www.mbsplugins.de/archive/2023-12-13/MBS_Plugin_Advent_calendar_13_/monkeybreadsoftware_blog_filemaker)
- [Tips and tricks with MBS](https://www.mbsplugins.de/archive/2023-08-10/Tips_and_tricks_with_MBS/monkeybreadsoftware_blog_filemaker)
- [New column names in an Excel document](https://www.mbsplugins.de/archive/2019-05-14/New_column_names_in_an_Excel_d/monkeybreadsoftware_blog_filemaker)
- [How to use XL functions with MBS FileMaker Plugin](https://www.mbsplugins.de/archive/2015-02-09/How_to_use_XL_functions_with_M/monkeybreadsoftware_blog_filemaker)

### FileMaker Magazin

- [Ausgabe 1/2025, Seite 27](https://filemaker-magazin.de/neuigkeit/4282-Appetithappen-FMM_202501)
- [Ausgabe 5/2022, Seite 22](https://filemaker-magazin.de/neuigkeit/4196-Appetithappen-FMM_202205)

This function checks for a license.

Created 18th August 2014 , last changed 19th April 2016

  
[XL.Book.PictureCount](XLBookPictureCount.md) - [XL.Book.ReleaseAll](XLBookReleaseAll.md)

[HTML Version](XLBookRelease.shtml)