United States (English) Sign in
Home Products Office 365 Docs Samples Downloads Training How To Support Forums
Office and SharePoint development > Office client development > Office 2010 > Excel 2010 > Excel 2010 Primary Interop Assembly Reference > Class Library > Microsoft.Office.Interop.Excel Namespace > WorkbookEvents_SheetPivotTableBeforeDiscardChangesEventHandler Delegate
Office and SharePoint development
Office client development
Office 2010
Excel 2010
Excel 2010 Primary Interop Assembly Reference
Class Library
Microsoft.Office.Interop.Excel Namespace
_Application Interface
_Chart Interface
_Global Interface
_IOLEObject Interface
_IQueryTable Interface
_OLEObject Interface
_QueryTable Interface
_Workbook Interface
_Worksheet Interface
AboveAverage Interface
Action Interface
Actions Interface
AddIn Interface
AddIns Interface
AddIns2 Interface
Adjustments Interface
AllowEditRange Interface
AllowEditRanges Interface
AppEvents Interface
AppEvents_AfterCalculateEventHandler Delegate
AppEvents_Event Interface
AppEvents_NewWorkbookEventHandler Delegate
AppEvents_ProtectedViewWindowActivateEventHandler Delegate
AppEvents_ProtectedViewWindowBeforeCloseEventHandler Delegate
AppEvents_ProtectedViewWindowBeforeEditEventHandler Delegate
AppEvents_ProtectedViewWindowDeactivateEventHandler Delegate
AppEvents_ProtectedViewWindowOpenEventHandler Delegate
AppEvents_ProtectedViewWindowResizeEventHandler Delegate
AppEvents_SheetActivateEventHandler Delegate
AppEvents_SheetBeforeDoubleClickEventHandler Delegate
AppEvents_SheetBeforeRightClickEventHandler Delegate
AppEvents_SheetCalculateEventHandler Delegate
AppEvents_SheetChangeEventHandler Delegate
AppEvents_SheetDeactivateEventHandler Delegate
AppEvents_SheetFollowHyperlinkEventHandler Delegate
AppEvents_SheetPivotTableAfterValueChangeEventHandler Delegate
AppEvents_SheetPivotTableBeforeAllocateChangesEventHandler Delegate
AppEvents_SheetPivotTableBeforeCommitChangesEventHandler Delegate
AppEvents_SheetPivotTableBeforeDiscardChangesEventHandler Delegate
AppEvents_SheetPivotTableUpdateEventHandler Delegate
AppEvents_SheetSelectionChangeEventHandler Delegate
AppEvents_SinkHelper Class
AppEvents_WindowActivateEventHandler Delegate
AppEvents_WindowDeactivateEventHandler Delegate
AppEvents_WindowResizeEventHandler Delegate
AppEvents_WorkbookActivateEventHandler Delegate
AppEvents_WorkbookAddinInstallEventHandler Delegate
AppEvents_WorkbookAddinUninstallEventHandler Delegate
AppEvents_WorkbookAfterSaveEventHandler Delegate
AppEvents_WorkbookAfterXmlExportEventHandler Delegate
AppEvents_WorkbookAfterXmlImportEventHandler Delegate
AppEvents_WorkbookBeforeCloseEventHandler Delegate
AppEvents_WorkbookBeforePrintEventHandler Delegate
AppEvents_WorkbookBeforeSaveEventHandler Delegate
AppEvents_WorkbookBeforeXmlExportEventHandler Delegate
AppEvents_WorkbookBeforeXmlImportEventHandler Delegate
AppEvents_WorkbookDeactivateEventHandler Delegate
AppEvents_WorkbookNewChartEventHandler Delegate
AppEvents_WorkbookNewSheetEventHandler Delegate
AppEvents_WorkbookOpenEventHandler Delegate
AppEvents_WorkbookPivotTableCloseConnectionEventHandler Delegate
AppEvents_WorkbookPivotTableOpenConnectionEventHandler Delegate
AppEvents_WorkbookRowsetCompleteEventHandler Delegate
AppEvents_WorkbookSyncEventHandler Delegate
Application Interface
ApplicationClass Class
Arc Interface
Arcs Interface
Areas Interface
AutoCorrect Interface
AutoFilter Interface
AutoRecover Interface
Axes Interface
Axis Interface
AxisTitle Interface
Border Interface
Borders Interface
Button Interface
Buttons Interface
CalculatedFields Interface
CalculatedItems Interface
CalculatedMember Interface
CalculatedMembers Interface
CalloutFormat Interface
CellFormat Interface
Characters Interface
Chart Interface
ChartArea Interface
ChartClass Class
ChartColorFormat Interface
ChartEvents Interface
ChartEvents_ActivateEventHandler Delegate
ChartEvents_BeforeDoubleClickEventHandler Delegate
ChartEvents_BeforeRightClickEventHandler Delegate
ChartEvents_CalculateEventHandler Delegate
ChartEvents_DeactivateEventHandler Delegate
ChartEvents_DragOverEventHandler Delegate
ChartEvents_DragPlotEventHandler Delegate
ChartEvents_Event Interface
ChartEvents_MouseDownEventHandler Delegate
ChartEvents_MouseMoveEventHandler Delegate
ChartEvents_MouseUpEventHandler Delegate
ChartEvents_ResizeEventHandler Delegate
ChartEvents_SelectEventHandler Delegate
ChartEvents_SeriesChangeEventHandler Delegate
ChartEvents_SinkHelper Class
ChartFillFormat Interface
ChartFormat Interface
ChartGroup Interface
ChartGroups Interface
ChartObject Interface
ChartObjects Interface
Charts Interface
ChartTitle Interface
ChartView Interface
CheckBox Interface
CheckBoxes Interface
ColorFormat Interface
ColorScale Interface
ColorScaleCriteria Interface
ColorScaleCriterion Interface
ColorStop Interface
ColorStops Interface
Comment Interface
Comments Interface
ConditionValue Interface
Connections Interface
ConnectorFormat Interface
Constants Enumeration
ControlFormat Interface
Corners Interface
CubeField Interface
CubeFields Interface
CustomProperties Interface
CustomProperty Interface
CustomView Interface
CustomViews Interface
Databar Interface
DataBarBorder Interface
DataLabel Interface
DataLabels Interface
DataTable Interface
DefaultWebOptions Interface
Diagram Interface
DiagramNode Interface
DiagramNodeChildren Interface
DiagramNodes Interface
Dialog Interface
DialogFrame Interface
Dialogs Interface
DialogSheet Interface
DialogSheets Interface
DialogSheetView Interface
DisplayFormat Interface
DisplayUnitLabel Interface
DocEvents Interface
DocEvents_ActivateEventHandler Delegate
DocEvents_BeforeDoubleClickEventHandler Delegate
DocEvents_BeforeRightClickEventHandler Delegate
DocEvents_CalculateEventHandler Delegate
DocEvents_ChangeEventHandler Delegate
DocEvents_DeactivateEventHandler Delegate
DocEvents_Event Interface
DocEvents_FollowHyperlinkEventHandler Delegate
DocEvents_PivotTableAfterValueChangeEventHandler Delegate
DocEvents_PivotTableBeforeAllocateChangesEventHandler Delegate
DocEvents_PivotTableBeforeCommitChangesEventHandler Delegate
DocEvents_PivotTableBeforeDiscardChangesEventHandler Delegate
DocEvents_PivotTableChangeSyncEventHandler Delegate
DocEvents_PivotTableUpdateEventHandler Delegate
DocEvents_SelectionChangeEventHandler Delegate
DocEvents_SinkHelper Class
DownBars Interface
Drawing Interface
DrawingObjects Interface
Drawings Interface
DropDown Interface
DropDowns Interface
DropLines Interface
EditBox Interface
EditBoxes Interface
Error Interface
ErrorBars Interface
ErrorCheckingOptions Interface
Errors Interface
FileExportConverter Interface
FileExportConverters Interface
FillFormat Interface
Filter Interface
Filters Interface
Floor Interface
Font Interface
FormatColor Interface
FormatCondition Interface
FormatConditions Interface
FreeformBuilder Interface
Global Interface
GlobalClass Class
Graphic Interface
Gridlines Interface
GroupBox Interface
GroupBoxes Interface
GroupObject Interface
GroupObjects Interface
GroupShapes Interface
HeaderFooter Interface
HiLoLines Interface
HPageBreak Interface
HPageBreaks Interface
Hyperlink Interface
Hyperlinks Interface
IAboveAverage Interface
IAction Interface
IActions Interface
IAddIn Interface
IAddIns Interface
IAddIns2 Interface
IAllowEditRange Interface
IAllowEditRanges Interface
IAppEvents Interface
IArc Interface
IArcs Interface
IAreas Interface
IAutoCorrect Interface
IAutoFilter Interface
IAutoRecover Interface
IAxes Interface
IAxis Interface
IAxisTitle Interface
IBorder Interface
IBorders Interface
IButton Interface
IButtons Interface
ICalculatedFields Interface
ICalculatedItems Interface
ICalculatedMember Interface
ICalculatedMembers Interface
ICanvasShapes Interface
ICellFormat Interface
ICharacters Interface
IChartArea Interface
IChartColorFormat Interface
IChartEvents Interface
IChartFillFormat Interface
IChartFormat Interface
IChartGroup Interface
IChartGroups Interface
IChartObject Interface
IChartObjects Interface
ICharts Interface
IChartTitle Interface
IChartView Interface
ICheckBox Interface
ICheckBoxes Interface
IColorScale Interface
IColorScaleCriteria Interface
IColorScaleCriterion Interface
IColorStop Interface
IColorStops Interface
IComment Interface
IComments Interface
Icon Interface
IconCriteria Interface
IconCriterion Interface
IConditionValue Interface
IConnections Interface
IConnectorFormat Interface
IconSet Interface
IconSetCondition Interface
IconSets Interface
IControlFormat Interface
ICorners Interface
ICustomProperties Interface
ICustomProperty Interface
ICustomView Interface
ICustomViews Interface
IDatabar Interface
IDataBarBorder Interface
IDataLabel Interface
IDataLabels Interface
IDataTable Interface
IDiagram Interface
IDialog Interface
IDialogFrame Interface
IDialogs Interface
IDialogSheet Interface
IDialogSheets Interface
IDialogSheetView Interface
IDisplayFormat Interface
IDisplayUnitLabel Interface
IDocEvents Interface
IDownBars Interface
IDrawing Interface
IDrawingObjects Interface
IDrawings Interface
IDropDown Interface
IDropDowns Interface
IDropLines Interface
IDummy Interface
IEditBox Interface
IEditBoxes Interface
IError Interface
IErrorBars Interface
IErrorCheckingOptions Interface
IErrors Interface
IFileExportConverter Interface
IFileExportConverters Interface
IFilter Interface
IFilters Interface
IFloor Interface
IFont Interface
IFormatColor Interface
IFormatCondition Interface
IFormatConditions Interface
IFreeformBuilder Interface
IGraphic Interface
IGridlines Interface
IGroupBox Interface
IGroupBoxes Interface
IGroupObject Interface
IGroupObjects Interface
IGroupShapes Interface
IHeaderFooter Interface
IHiLoLines Interface
IHPageBreak Interface
IHPageBreaks Interface
IHyperlink Interface
IHyperlinks Interface
IIcon Interface
IIconCriteria Interface
IIconCriterion Interface
IIconSet Interface
IIconSetCondition Interface
IIconSets Interface
IInterior Interface
ILabel Interface
ILabels Interface
ILeaderLines Interface
ILegend Interface
ILegendEntries Interface
ILegendEntry Interface
ILegendKey Interface
ILine Interface
ILinearGradient Interface
ILines Interface
ILinkFormat Interface
IListBox Interface
IListBoxes Interface
IListColumn Interface
IListColumns Interface
IListDataFormat Interface
IListObject Interface
IListObjects Interface
IListRow Interface
IListRows Interface
IMailer Interface
IMenu Interface
IMenuBar Interface
IMenuBars Interface
IMenuItem Interface
IMenuItems Interface
IMenus Interface
IModule Interface
IModules Interface
IModuleView Interface
IMultiThreadedCalculation Interface
IName Interface
INames Interface
INegativeBarFormat Interface
Interior Interface
IODBCConnection Interface
IODBCError Interface
IODBCErrors Interface
IOLEDBConnection Interface
IOLEDBError Interface
IOLEDBErrors Interface
IOLEFormat Interface
IOLEObjectEvents Interface
IOLEObjects Interface
IOptionButton Interface
IOptionButtons Interface
IOutline Interface
IOval Interface
IOvals Interface
IPage Interface
IPages Interface
IPageSetup Interface
IPane Interface
IPanes Interface
IParameter Interface
IParameters Interface
IPhonetic Interface
IPhonetics Interface
IPicture Interface
IPictures Interface
IPivotAxis Interface
IPivotCache Interface
IPivotCaches Interface
IPivotCell Interface
IPivotField Interface
IPivotFields Interface
IPivotFilter Interface
IPivotFilters Interface
IPivotFormula Interface
IPivotFormulas Interface
IPivotItem Interface
IPivotItemList Interface
IPivotItems Interface
IPivotLayout Interface
IPivotLine Interface
IPivotLineCells Interface
IPivotLines Interface
IPivotTable Interface
IPivotTableChangeList Interface
IPivotTables Interface
IPlotArea Interface
IPoint Interface
IPoints Interface
IProtectedViewWindow Interface
IProtectedViewWindows Interface
IProtection Interface
IPublishObjects Interface
IQueryTables Interface
IRange Interface
IRanges Interface
IRecentFile Interface
IRecentFiles Interface
IRectangle Interface
IRectangles Interface
IRectangularGradient Interface
IRefreshEvents Interface
IResearch Interface
IRoutingSlip Interface
IRTD Interface
IRtdServer Interface
IRTDUpdateEvent Interface
IScenario Interface
IScenarios Interface
IScrollBar Interface
IScrollBars Interface
ISeries Interface
ISeriesCollection Interface
ISeriesLines Interface
IServerViewableItems Interface
IShape Interface
IShapeRange Interface
IShapes Interface
ISheetViews Interface
ISlicer Interface
ISlicerCache Interface
ISlicerCacheLevel Interface
ISlicerCacheLevels Interface
ISlicerCaches Interface
ISlicerItem Interface
ISlicerItems Interface
ISlicerPivotTables Interface
ISlicers Interface
ISmartTag Interface
ISmartTagAction Interface
ISmartTagActions Interface
ISmartTagOptions Interface
ISmartTagRecognizer Interface
ISmartTagRecognizers Interface
ISmartTags Interface
ISort Interface
ISortField Interface
ISortFields Interface
ISoundNote Interface
ISparkAxes Interface
ISparkColor Interface
ISparkHorizontalAxis Interface
ISparkline Interface
ISparklineGroup Interface
ISparklineGroups Interface
ISparkPoints Interface
ISparkVerticalAxis Interface
ISpeech Interface
ISpellingOptions Interface
ISpinner Interface
ISpinners Interface
IStyle Interface
IStyles Interface
ITab Interface
ITableStyle Interface
ITableStyleElement Interface
ITableStyleElements Interface
ITableStyles Interface
ITextBox Interface
ITextBoxes Interface
ITextFrame Interface
ITickLabels Interface
IToolbar Interface
IToolbarButton Interface
IToolbarButtons Interface
IToolbars Interface
ITop10 Interface
ITrendline Interface
ITrendlines Interface
IUniqueValues Interface
IUpBars Interface
IUsedObjects Interface
IUserAccess Interface
IUserAccessList Interface
IValidation Interface
IValueChange Interface
IVPageBreak Interface
IVPageBreaks Interface
IWalls Interface
IWatch Interface
IWatches Interface
IWindow Interface
IWindows Interface
IWorkbookConnection Interface
IWorkbookEvents Interface
IWorksheetFunction Interface
IWorksheets Interface
IWorksheetView Interface
IXmlDataBinding Interface
IXmlMap Interface
IXmlMaps Interface
IXmlNamespace Interface
IXmlNamespaces Interface
IXmlSchema Interface
IXmlSchemas Interface
IXPath Interface
Label Interface
Labels Interface
LeaderLines Interface
Legend Interface
LegendEntries Interface
LegendEntry Interface
LegendKey Interface
Line Interface
LinearGradient Interface
LineFormat Interface
Lines Interface
LinkFormat Interface
ListBox Interface
ListBoxes Interface
ListColumn Interface
ListColumns Interface
ListDataFormat Interface
ListObject Interface
ListObjects Interface
ListRow Interface
ListRows Interface
Mailer Interface
Menu Interface
MenuBar Interface
MenuBars Interface
MenuItem Interface
MenuItems Interface
Menus Interface
Module Interface
Modules Interface
ModuleView Interface
MultiThreadedCalculation Interface
Name Interface
Names Interface
NegativeBarFormat Interface
ODBCConnection Interface
ODBCError Interface
ODBCErrors Interface
OLEDBConnection Interface
OLEDBError Interface
OLEDBErrors Interface
OLEFormat Interface
OLEObject Interface
OLEObjectClass Class
OLEObjectEvents Interface
OLEObjectEvents_Event Interface
OLEObjectEvents_GotFocusEventHandler Delegate
OLEObjectEvents_LostFocusEventHandler Delegate
OLEObjectEvents_SinkHelper Class
OLEObjects Interface
OptionButton Interface
OptionButtons Interface
Outline Interface
Oval Interface
Ovals Interface
Page Interface
Pages Interface
PageSetup Interface
Pane Interface
Panes Interface
Parameter Interface
Parameters Interface
Phonetic Interface
Phonetics Interface
Picture Interface
PictureFormat Interface
Pictures Interface
PivotAxis Interface
PivotCache Interface
PivotCaches Interface
PivotCell Interface
PivotField Interface
PivotFields Interface
PivotFilter Interface
PivotFilters Interface
PivotFormula Interface
PivotFormulas Interface
PivotItem Interface
PivotItemList Interface
PivotItems Interface
PivotLayout Interface
PivotLine Interface
PivotLineCells Interface
PivotLines Interface
PivotTable Interface
PivotTableChangeList Interface
PivotTables Interface
PlotArea Interface
Point Interface
Points Interface
ProtectedViewWindow Interface
ProtectedViewWindows Interface
Protection Interface
PublishObject Interface
PublishObjects Interface
QueryTable Interface
QueryTableClass Class
QueryTables Interface
Range Interface
Ranges Interface
RecentFile Interface
RecentFiles Interface
Rectangle Interface
Rectangles Interface
RectangularGradient Interface
RefreshEvents Interface
RefreshEvents_AfterRefreshEventHandler Delegate
RefreshEvents_BeforeRefreshEventHandler Delegate
RefreshEvents_Event Interface
RefreshEvents_SinkHelper Class
Research Interface
RoutingSlip Interface
RTD Interface
Scenario Interface
Scenarios Interface
ScrollBar Interface
ScrollBars Interface
Series Interface
SeriesCollection Interface
SeriesLines Interface
ServerViewableItems Interface
ShadowFormat Interface
Shape Interface
ShapeNode Interface
ShapeNodes Interface
ShapeRange Interface
Shapes Interface
Sheets Interface
SheetViews Interface
Slicer Interface
SlicerCache Interface
SlicerCacheLevel Interface
SlicerCacheLevels Interface
SlicerCaches Interface
SlicerItem Interface
SlicerItems Interface
SlicerPivotTables Interface
Slicers Interface
SmartTag Interface
SmartTagAction Interface
SmartTagActions Interface
SmartTagOptions Interface
SmartTagRecognizer Interface
SmartTagRecognizers Interface
SmartTags Interface
Sort Interface
SortField Interface
SortFields Interface
SoundNote Interface
SparkAxes Interface
SparkColor Interface
SparkHorizontalAxis Interface
Sparkline Interface
SparklineGroup Interface
SparklineGroups Interface
SparkPoints Interface
SparkVerticalAxis Interface
Speech Interface
SpellingOptions Interface
Spinner Interface
Spinners Interface
Style Interface
Styles Interface
Tab Interface
TableStyle Interface
TableStyleElement Interface
TableStyleElements Interface
TableStyles Interface
TextBox Interface
TextBoxes Interface
TextEffectFormat Interface
TextFrame Interface
TextFrame2 Interface
ThreeDFormat Interface
TickLabels Interface
Toolbar Interface
ToolbarButton Interface
ToolbarButtons Interface
Toolbars Interface
Top10 Interface
TreeviewControl Interface
Trendline Interface
Trendlines Interface
UniqueValues Interface
UpBars Interface
UsedObjects Interface
UserAccess Interface
UserAccessList Interface
Validation Interface
ValueChange Interface
VPageBreak Interface
VPageBreaks Interface
Walls Interface
Watch Interface
Watches Interface
WebOptions Interface
Window Interface
Windows Interface
Workbook Interface
WorkbookClass Class
WorkbookConnection Interface
WorkbookEvents Interface
WorkbookEvents_ActivateEventHandler Delegate
WorkbookEvents_AddinInstallEventHandler Delegate
WorkbookEvents_AddinUninstallEventHandler Delegate
WorkbookEvents_AfterSaveEventHandler Delegate
WorkbookEvents_AfterXmlExportEventHandler Delegate
WorkbookEvents_AfterXmlImportEventHandler Delegate
WorkbookEvents_BeforeCloseEventHandler Delegate
WorkbookEvents_BeforePrintEventHandler Delegate
WorkbookEvents_BeforeSaveEventHandler Delegate
WorkbookEvents_BeforeXmlExportEventHandler Delegate
WorkbookEvents_BeforeXmlImportEventHandler Delegate
WorkbookEvents_DeactivateEventHandler Delegate
WorkbookEvents_Event Interface
WorkbookEvents_NewChartEventHandler Delegate
WorkbookEvents_NewSheetEventHandler Delegate
WorkbookEvents_OpenEventHandler Delegate
WorkbookEvents_PivotTableCloseConnectionEventHandler Delegate
WorkbookEvents_PivotTableOpenConnectionEventHandler Delegate
WorkbookEvents_RowsetCompleteEventHandler Delegate
WorkbookEvents_SheetActivateEventHandler Delegate
WorkbookEvents_SheetBeforeDoubleClickEventHandler Delegate
WorkbookEvents_SheetBeforeRightClickEventHandler Delegate
WorkbookEvents_SheetCalculateEventHandler Delegate
WorkbookEvents_SheetChangeEventHandler Delegate
WorkbookEvents_SheetDeactivateEventHandler Delegate
WorkbookEvents_SheetFollowHyperlinkEventHandler Delegate
WorkbookEvents_SheetPivotTableAfterValueChangeEventHandler Delegate
WorkbookEvents_SheetPivotTableBeforeAllocateChangesEventHandler Delegate
WorkbookEvents_SheetPivotTableBeforeCommitChangesEventHandler Delegate
WorkbookEvents_SheetPivotTableBeforeDiscardChangesEventHandler Delegate
WorkbookEvents_SheetPivotTableChangeSyncEventHandler Delegate
WorkbookEvents_SheetPivotTableUpdateEventHandler Delegate
WorkbookEvents_SheetSelectionChangeEventHandler Delegate
WorkbookEvents_SinkHelper Class
WorkbookEvents_SyncEventHandler Delegate
WorkbookEvents_WindowActivateEventHandler Delegate
WorkbookEvents_WindowDeactivateEventHandler Delegate
WorkbookEvents_WindowResizeEventHandler Delegate
Workbooks Interface
Worksheet Interface
WorksheetClass Class
WorksheetFunction Interface
Worksheets Interface
WorksheetView Interface
XlAboveBelow Enumeration
XlActionType Enumeration
XlAllocation Enumeration
XlAllocationMethod Enumeration
XlAllocationValue Enumeration
XlApplicationInternational Enumeration
XlApplyNamesOrder Enumeration
XlArabicModes Enumeration
XlArrangeStyle Enumeration
XlArrowHeadLength Enumeration
XlArrowHeadStyle Enumeration
XlArrowHeadWidth Enumeration
XlAutoFillType Enumeration
XlAutoFilterOperator Enumeration
XlAxisCrosses Enumeration
XlAxisGroup Enumeration
XlAxisType Enumeration
XlBackground Enumeration
XlBarShape Enumeration
XlBordersIndex Enumeration
XlBorderWeight Enumeration
XlBuiltInDialog Enumeration
XlCalcFor Enumeration
XlCalculatedMemberType Enumeration
XlCalculation Enumeration
XlCalculationInterruptKey Enumeration
XlCalculationState Enumeration
XlCategoryType Enumeration
XlCellChangedState Enumeration
XlCellInsertionMode Enumeration
XlCellType Enumeration
XlChartElementPosition Enumeration
XlChartGallery Enumeration
XlChartItem Enumeration
XlChartLocation Enumeration
XlChartPicturePlacement Enumeration
XlChartPictureType Enumeration
XlChartSplitType Enumeration
XlChartType Enumeration
XlCheckInVersionType Enumeration
XlClipboardFormat Enumeration
XlCmdType Enumeration
XlColorIndex Enumeration
XlColumnDataType Enumeration
XlCommandUnderlines Enumeration
XlCommentDisplayMode Enumeration
XlConditionValueTypes Enumeration
XlConnectionType Enumeration
XlConsolidationFunction Enumeration
XlContainsOperator Enumeration
XlCopyPictureFormat Enumeration
XlCorruptLoad Enumeration
XlCreator Enumeration
XlCredentialsMethod Enumeration
XlCubeFieldSubType Enumeration
XlCubeFieldType Enumeration
XlCutCopyMode Enumeration
XlCVError Enumeration
XlDataBarAxisPosition Enumeration
XlDataBarBorderType Enumeration
XlDataBarFillType Enumeration
XlDataBarNegativeColorType Enumeration
XlDataLabelPosition Enumeration
XlDataLabelSeparator Enumeration
XlDataLabelsType Enumeration
XlDataSeriesDate Enumeration
XlDataSeriesType Enumeration
XlDeleteShiftDirection Enumeration
XlDirection Enumeration
XlDisplayBlanksAs Enumeration
XlDisplayDrawingObjects Enumeration
XlDisplayUnit Enumeration
XlDupeUnique Enumeration
XlDVAlertStyle Enumeration
XlDVType Enumeration
XlDynamicFilterCriteria Enumeration
XlEditionFormat Enumeration
XlEditionOptionsOption Enumeration
XlEditionType Enumeration
XlEnableCancelKey Enumeration
XlEnableSelection Enumeration
XlEndStyleCap Enumeration
XlErrorBarDirection Enumeration
XlErrorBarInclude Enumeration
XlErrorBarType Enumeration
XlErrorChecks Enumeration
XlFileAccess Enumeration
XlFileFormat Enumeration
XlFileValidationPivotMode Enumeration
XlFillWith Enumeration
XlFilterAction Enumeration
XlFilterAllDatesInPeriod Enumeration
XlFindLookIn Enumeration
XlFixedFormatQuality Enumeration
XlFixedFormatType Enumeration
XlFormatConditionOperator Enumeration
XlFormatConditionType Enumeration
XlFormatFilterTypes Enumeration
XlFormControl Enumeration
XlFormulaLabel Enumeration
XlGenerateTableRefs Enumeration
XlGradientFillType Enumeration
XlHAlign Enumeration
XlHebrewModes Enumeration
XlHighlightChangesTime Enumeration
XlHtmlType Enumeration
XlIcon Enumeration
XlIconSet Enumeration
XlIMEMode Enumeration
XlImportDataAs Enumeration
XlInsertFormatOrigin Enumeration
XlInsertShiftDirection Enumeration
XlLayoutFormType Enumeration
XlLayoutRowType Enumeration
XlLegendPosition Enumeration
XlLineStyle Enumeration
XlLink Enumeration
XlLinkInfo Enumeration
XlLinkInfoType Enumeration
XlLinkStatus Enumeration
XlLinkType Enumeration
XlListConflict Enumeration
XlListDataType Enumeration
XlListObjectSourceType Enumeration
XlLocationInTable Enumeration
XlLookAt Enumeration
XlLookFor Enumeration
XlMailSystem Enumeration
XlMarkerStyle Enumeration
XlMeasurementUnits Enumeration
XlMouseButton Enumeration
XlMousePointer Enumeration
XlMSApplication Enumeration
XlOartHorizontalOverflow Enumeration
XlOartVerticalOverflow Enumeration
XlObjectSize Enumeration
XlOLEType Enumeration
XlOLEVerb Enumeration
XlOrder Enumeration
XlOrientation Enumeration
XlPageBreak Enumeration
XlPageBreakExtent Enumeration
XlPageOrientation Enumeration
XlPaperSize Enumeration
XlParameterDataType Enumeration
XlParameterType Enumeration
XlPasteSpecialOperation Enumeration
XlPasteType Enumeration
XlPattern Enumeration
XlPhoneticAlignment Enumeration
XlPhoneticCharacterType Enumeration
XlPictureAppearance Enumeration
XlPictureConvertorType Enumeration
XlPieSliceIndex Enumeration
XlPieSliceLocation Enumeration
XlPivotCellType Enumeration
XlPivotConditionScope Enumeration
XlPivotFieldCalculation Enumeration
XlPivotFieldDataType Enumeration
XlPivotFieldOrientation Enumeration
XlPivotFieldRepeatLabels Enumeration
XlPivotFilterType Enumeration
XlPivotFormatType Enumeration
XlPivotLineType Enumeration
XlPivotTableMissingItems Enumeration
XlPivotTableSourceType Enumeration
XlPivotTableVersionList Enumeration
XlPlacement Enumeration
XlPlatform Enumeration
XlPortugueseReform Enumeration
XlPrintErrors Enumeration
XlPrintLocation Enumeration
XlPriority Enumeration
XlPropertyDisplayedIn Enumeration
XlProtectedViewCloseReason Enumeration
XlProtectedViewWindowState Enumeration
XlPTSelectionMode Enumeration
XlQueryType Enumeration
XlRangeAutoFormat Enumeration
XlRangeValueDataType Enumeration
XlReferenceStyle Enumeration
XlReferenceType Enumeration
XlRemoveDocInfoType Enumeration
XlRgbColor Enumeration
XlRobustConnect Enumeration
XlRoutingSlipDelivery Enumeration
XlRoutingSlipStatus Enumeration
XlRowCol Enumeration
XlRunAutoMacro Enumeration
XlSaveAction Enumeration
XlSaveAsAccessMode Enumeration
XlSaveConflictResolution Enumeration
XlScaleType Enumeration
XlSearchDirection Enumeration
XlSearchOrder Enumeration
XlSearchWithin Enumeration
XlSheetType Enumeration
XlSheetVisibility Enumeration
XlSizeRepresents Enumeration
XlSlicerCrossFilterType Enumeration
XlSlicerSort Enumeration
XlSmartTagControlType Enumeration
XlSmartTagDisplayMode Enumeration
XlSortDataOption Enumeration
XlSortMethod Enumeration
XlSortMethodOld Enumeration
XlSortOn Enumeration
XlSortOrder Enumeration
XlSortOrientation Enumeration
XlSortType Enumeration
XlSourceType Enumeration
XlSpanishModes Enumeration
XlSparklineRowCol Enumeration
XlSparkScale Enumeration
XlSparkType Enumeration
XlSpeakDirection Enumeration
XlSpecialCellsValue Enumeration
XlStdColorScale Enumeration
XlSubscribeToFormat Enumeration
XlSubtototalLocationType Enumeration
XlSummaryColumn Enumeration
XlSummaryReportType Enumeration
XlSummaryRow Enumeration
XlTableStyleElementType Enumeration
XlTabPosition Enumeration
XlTextParsingType Enumeration
XlTextQualifier Enumeration
XlTextVisualLayoutType Enumeration
XlThemeColor Enumeration
XlThemeFont Enumeration
XlThreadMode Enumeration
XlTickLabelOrientation Enumeration
XlTickLabelPosition Enumeration
XlTickMark Enumeration
XlTimePeriods Enumeration
XlTimeUnit Enumeration
XlToolbarProtection Enumeration
XlTopBottom Enumeration
XlTotalsCalculation Enumeration
XlTrendlineType Enumeration
XlUnderlineStyle Enumeration
XlUpdateLinks Enumeration
XlVAlign Enumeration
XlWBATemplate Enumeration
XlWebFormatting Enumeration
XlWebSelectionType Enumeration
XlWindowState Enumeration
XlWindowType Enumeration
XlWindowView Enumeration
XlXLMMacroType Enumeration
XlXmlExportResult Enumeration
XlXmlImportResult Enumeration
XlXmlLoadOption Enumeration
XlYesNoGuess Enumeration
XmlDataBinding Interface
XmlMap Interface
XmlMaps Interface
XmlNamespace Interface
XmlNamespaces Interface
XmlSchema Interface
XmlSchemas Interface
XPath Interface
Expand Minimize
This topic has not yet been rated - Rate this topic

WorkbookEvents_SheetPivotTableBeforeDiscardChangesEventHandler Delegate

Office 2010

A Delegate type used to add an event handler for the SheetPivotTableBeforeDiscardChanges event. The SheetPivotTableBeforeDiscardChanges event occurs before changes to a PivotTable are discarded.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
C#
VB
Copy 
[ComVisibleAttribute(false)]
public delegate void WorkbookEvents_SheetPivotTableBeforeDiscardChangesEventHandler(
	Object Sh,
	PivotTable TargetPivotTable,
	int ValueChangeStart,
	int ValueChangeEnd
)

Parameters

Sh
Type: System.Object
The worksheet that contains the PivotTable.
TargetPivotTable
Type: Microsoft.Office.Interop.Excel.PivotTable
The PivotTable that contains the changes to discard.
ValueChangeStart
Type: System.Int32
The index to the first change in the associated PivotTableChangeList object. The index is specified by the Order property of the ValueChange object in the PivotTableChangeList collection.
ValueChangeEnd
Type: System.Int32
The index to the last change in the associated PivotTableChangeList object. The index is specified by the Order property of the ValueChange object in the PivotTableChangeList collection.
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.