CalculateFullRebuild Method

Optimizes the internal representation of formulas and data in this workbook set and calculates all of the formulas.

[Visual Basic]
Overridable Sub CalculateFullRebuild() 

[C#]
virtual void CalculateFullRebuild();

[C++]
virtual void CalculateFullRebuild(); 

[C++/CLI]
virtual void CalculateFullRebuild(); 

Remarks

CalculateFullRebuild is a very expensive operation. Typically, it will prove beneficial when a set of one or more workbooks are loaded and/or created, populated with values and formulas, optimized with CalculateFullRebuild, and then modified and calculated many times.

Calling System.GC.Collect after rebuilding and before the next calculation is triggered typically results in faster calculation. However, calling System.GC.Collect in a server environment is rarely a good idea.

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

See Also

IWorkbookSet Interface  | IWorkbookSet Members  | BackgroundCalculation Property  | Calculation Property  | CalculationOnDemand Property  | Calculate Method  | CalculateFull Method

See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.

Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.

SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.