'Declaration Public Sub ResumeNotificationProcessing( _ ByVal dirtyAllFormulas As Boolean _ )
public void ResumeNotificationProcessing( bool dirtyAllFormulas )
While notifications are suspended by the SuspendNotificationProcessing method, the _CALCMANAGER_ loses track of what effects these changes may have had on the dependencies between formulas. If any changes affecting the calc network have been made (including adding, removing, or changing any formula; and adding, removing or changing references, including inserting values that may indirectly affect the index of a reference within a range) then this method must be called with a true dirtyAllFormulas argument.
If the calc network has been affected by changes, and dirtyAllFormulas is not true when resuming notifications, then the expected consequences that can manifest themselves may include some references not being re-calculated, or some formulas indicating a result that may be based on old reference values. Developers should only indicate false for dirtyAllFormulas when they are absolutely certain their changes could not have affected the calc network.
Often it is faster to suspend notifications, make significant changes, and subsequently resume notifications by dirtying all formulas, than to make multiple changes with notifications ongoing. This method and SuspendNotificationProcessing exist to allow developers to determine for themselves when this trade-off is best made in their applications, and optimize performance accordingly.
Resuming notification processing also resumes all calculations, as if ResumeCalc had been called.
Target Platforms: Windows 10, Windows 8.1, Windows 8, 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