excel.interfaces.pivotfieldloadoptions.yml

### YamlMime:TSType
name: Excel.Interfaces.PivotFieldLoadOptions
uid: 'excel!Excel.Interfaces.PivotFieldLoadOptions:interface'
package: excel!
fullName: Excel.Interfaces.PivotFieldLoadOptions
summary: Represents the Excel PivotField.
remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
type: interface
properties:
  - name: $all
    uid: 'excel!Excel.Interfaces.PivotFieldLoadOptions#$all:member'
    package: excel!
    fullName: $all
    summary: >-
      Specifying `$all` for the LoadOptions loads all the scalar properties (e.g.: `Range.address`<!-- -->) but not the
      navigational properties (e.g.: `Range.format.fill.color`<!-- -->).
    remarks: ''
    isPreview: false
    isDeprecated: false
    syntax:
      content: '$all?: boolean;'
      return:
        type: boolean
  - name: id
    uid: 'excel!Excel.Interfaces.PivotFieldLoadOptions#id:member'
    package: excel!
    fullName: id
    summary: ID of the PivotField.
    remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'id?: boolean;'
      return:
        type: boolean
  - name: name
    uid: 'excel!Excel.Interfaces.PivotFieldLoadOptions#name:member'
    package: excel!
    fullName: name
    summary: Name of the PivotField.
    remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'name?: boolean;'
      return:
        type: boolean
  - name: showAllItems
    uid: 'excel!Excel.Interfaces.PivotFieldLoadOptions#showAllItems:member'
    package: excel!
    fullName: showAllItems
    summary: Determines whether to show all items of the PivotField.
    remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'showAllItems?: boolean;'
      return:
        type: boolean
  - name: subtotals
    uid: 'excel!Excel.Interfaces.PivotFieldLoadOptions#subtotals:member'
    package: excel!
    fullName: subtotals
    summary: Subtotals of the PivotField.
    remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'subtotals?: boolean;'
      return:
        type: boolean