Multithreading and Memory Management

Last modified: November 04, 2011

Applies to: Excel 2010 | Office 2010 | VBA | Visual Studio

Proper handling of memory is vital to creating reliable XLL add-ins for Microsoft Excel. Failure to allocate appropriate memory buffers and free them when they are no longer needed reduces performance, creates resource contention, and destabilizes Excel.

Beginning with Microsoft Office Excel 2007, you can configure Excel to use up to 1,024 concurrent threads when recalculating. In some cases, especially when multiple processors are available or with user-defined functions running on clustered servers, multithreading can improve performance.

The following topics describe how to manage memory and threads in XLLs: