Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
ConsolidationOptions Property
Collapse the table of content
Expand the table of content

Worksheet.ConsolidationOptions Property

Gets a three-element Array of consolidation options.

Namespace:  Microsoft.Office.Tools.Excel
Assemblies:   Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

Object ConsolidationOptions { get; }

Property Value

Type: System.Object
A three-element Array of consolidation options.

If an element in the returned array is true, then the corresponding option is set. The three elements in the array are:

Element

Meaning

1

Use labels in top row

2

Use labels in left column

3

Create links to source data

Show:
© 2015 Microsoft