API Reference

Class

ExcelPivotSourceUpdateOptions

Namespace OfficeIMO.Excel
Assembly OfficeIMO.Excel
Modifiers sealed

Controls safety checks applied when an existing pivot table source is changed.

Inheritance

  • Object
  • ExcelPivotSourceUpdateOptions

Usage

This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.

Accepted by parameters

Constructors

public ExcelPivotSourceUpdateOptions() #

Properties

public Boolean RequireMatchingHeaders { get; set; } #

When true, the new source header names must match the existing pivot cache database fields. Field count must always remain stable because this operation does not rebuild pivot field definitions.

public Boolean AllowSharedCacheUpdate { get; set; } #

When true, a cache shared by multiple pivot tables may be updated. All affected pivots are returned in the result.