CalculateFullRebuild Method (IWorkbookSet)

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

Syntax

Visual Basic
C#
Delphi
JScript
Managed Extensions for C++
C++/CLI

'Declaration
 
Sub CalculateFullRebuild()

'Usage
 
Dim instance As IWorkbookSet
 
instance.CalculateFullRebuild()

void CalculateFullRebuild()

procedure CalculateFullRebuild();

function CalculateFullRebuild();

void CalculateFullRebuild();

void CalculateFullRebuild();

Remarks

IWorkbookSet.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

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

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