Skip to main content
SearchCtrl K
Community

Source code

OfficeIMO.NET libraries, PowerShell module, CLI, Studio and browser tools 579 stars

Talk and help

DiscordQuestions, ideas and show and tell Report an issueBugs and feature requests SponsorFund ongoing development

Mode

Background

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Search the whole siteOpen search page →
Documentation Search all OfficeIMO/

API Reference

Class

ExcelPivotSourceUpdateOptions

Edit on GitHub
Namespace OfficeIMO.Excel
Assembly OfficeIMO.Excel
Source revision e31b305980e3 with working tree changes
Source ExcelPivotSourceUpdateOptions.cs:10
Modifiers sealed

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

Inheritance

  • Object
  • ExcelPivotSourceUpdateOptions

Usage

Explore 1 API references to this type

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

Accepted by parameters 1

Constructors

public ExcelPivotSourceUpdateOptions() #
ExcelPivotSourceUpdateOptions.cs:10

Properties

public Boolean RequireMatchingHeaders { get; set; } #
ExcelPivotSourceUpdateOptions.cs:10

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; } #
ExcelPivotSourceUpdateOptions.cs:15

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