New Objects in 2016
| Application | |
| Assistant | (Hidden in 2016) |
| SaveISO8601Dates | (Hidden in 2016) |
| ShowWindowsInTaskbar | (Hidden in 2016) |
| Chart | |
| ShowExpandCollapseEntireFieldButtons (Property) | True to display the Expand Entire Field and Collapse Entire Field buttons on the specified pivot chart. Read/write Boolean. |
| ChartGroup | |
| BinsCountValue (Property) | Specifies the number of bins in the histogram chart. Read/write Long. |
| BinsOverflowEnabled (Property) | Specifies whether a bin for values above the BinsOverflowValue is enabled. Read/write Boolean. |
| BinsOverflowValue (Property) | If an BinsOverflowEnabled is True, specifies the value above which an overflow bin is displayed. Read/write Double. |
| BinsType (Property) | Specifies how the horizontal axis of the histogram chart is formatted, by bins type. Read/write XlBinsType. |
| BinsUnderflowEnabled (Property) | Specifies whether a bin for values below the BinsUnderflowValue is enabled. Read/write Boolean. |
| BinsUnderflowValue (Property) | If an BinsUnderflowEnabled is True, specifies the value below which an underflow bin is displayed. Read/write Double. |
| BinWidthValue (Property) | Specifies the number of points in each range. Read/write Double. |
| CubeField | |
| AutoGroup (Property) | Automatically groups the cube fields in an OLAP cube, optionally in the specified orientation and/or at the specified position. |
| Model | |
| ModelFormatBoolean (Property) | Returns a ModelFormatBoolean object that represents formatting of type true/false in the data model. Read-only. |
| ModelFormatCurrency (Property) | Returns a ModelFormatCurrency object that represents formatting of type currency in the data model. Read-only. |
| ModelFormatDate (Property) | Returns a ModelFormatDate object that represents formatting of type date in the data model. Read-only. |
| ModelFormatDecimalNumber (Property) | Returns a ModelFormatDecimalNumber object that represents formatting of type decimal number in the data model. Read-only. |
| ModelFormatGeneral (Property) | Returns a ModelFormatGeneral object that represents formatting of type general in the data model. Read-only. |
| ModelFormatPercentageNumber (Property) | Returns a ModelFormatPercentageNumber object that represents formatting of type percentage number in the data model. Read-only. |
| ModelFormatScientificNumber (Property) | Returns a ModelFormatScientificNumber object that represents formatting of type scientific number in the data model. Read-only. |
| ModelFormatWholeNumber (Property) | Returns a ModelFormatWholeNumber object that represents formatting of type whole number in the data model. Read-only. |
| ModelMeasures (Property) | Returns a ModelMeasures object that represents the collection of model measures in the data model. Read-only. |
| ModelConnection | |
| CalculatedMembers (Property) | Returns a CalculatedMembers object that represents the calculated members in the model connection. |
| ModelFormatBoolean (new) | Represents the format to be used for a model measure in the data model. |
| Application (Property) | When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long. |
| Parent (Property) | Returns the parent object for the specified object. Read-only. |
| Object (Property) | Represents the format to be used for a model measure in the data model. |
| ModelFormatCurrency (new) | Represents the format to be used for a model measure in the data model. |
| Application (Property) | When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long. |
| DecimalPlaces (Property) | Specifies the number of decimal places after the dot. Read/write Long. |
| Parent (Property) | Returns the parent object for the specified object. Read-only |
| Symbol (Property) | Specifies the symbol to use to represent the currency. Read/write String. |
| ModelFormatDate (new) | Represents the format to be used for a model measure in the data model. |
| Application (Property) | When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long. |
| FormatString (Property) | Specifies the date format, for example, " dd/mm/yy ". Read/write String. |
| Parent (Property) | Returns the parent object for the specified object. Read-only. |
| ModelFormatDecimalNumber (new) | Represents the format to be used for a model measure in the data model. |
| Application (Property) | When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long. |
| DecimalPlaces (Property) | Specifies the number of decimal places after the dot. Read/write Long. |
| Parent (Property) | Returns the parent object for the specified object. Read-only. |
| UseThousandSeparator (Property) | Specifies whether to display commas between thousands. Read/write Boolean. |
| ModelFormatGeneral (new) | Represents the format to be used for a model measure in the data model. |
| Application (Property) | When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long. |
| Parent (Property) | Returns the parent object for the specified object. Read-only. |
| ModelFormatPercentageNumber (new) | Represents the format to be used for a model measure in the data model. |
| Application (Property) | When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long. |
| DecimalPlaces (Property) | Specifies the number of decimal places after the dot. Read/write Long. |
| Parent (Property) | Returns the parent object for the specified object. Read-only. |
| UseThousandSeparator (Property) | Specifies whether to display commas between thousands. Read/write Boolean. |
| ModelFormatScientificNumber (new) | Represents the format to be used for a model measure in the data model. |
| Application (Property) | When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long. |
| DecimalPlaces (Property) | Specifies the number of decimal places after the dot. Read/write Long. |
| Parent (Property) | Returns the parent object for the specified object. Read-only. |
| ModelFormatWholeNumber (new) | Represents the format to be used for a model measure in the data model. |
| Application (Property) | When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long. |
| Parent (Property) | Returns the parent object for the specified object. Read-only. |
| UseThousandSeparator (Property) | Specifies whether to display commas between thousands. Read/write Boolean. |
| ModelMeasure (new) | Represents a single ModelMeasure object in theModelMeasures collection. |
| Application (Property) | When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only. |
| AssociatedTable (Property) | Specifies the table that contains the model measure, as displayed in the Field List task pane. Read/writeModelTable. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long. |
| Delete (Method) | Deletes the model measure from the data model. |
| Description (Method) | The description of the model measure. Read/write String. |
| FormatInformation (Method) | The format of the model measure. Read/write Variant. |
| Formula (Method) | The Data Analysis Expressions (DAX) formula of the model measure. Read/write String. |
| Name (Method) | The name of the model measure. Read/write String. |
| Parent (Property) | Returns the parent object for the specified object. Read-only. |
| ModelMeasures (new) | A collection of ModelMeasure objects. |
| Add (Method) | Adds a model measure to the model. |
| Application (Property) | When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only. |
| Count (Method) | Returns an integer that represents the number of objects in the collection. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long. |
| Item (Method) | Returns a single object from a collection |
| Parent (Property) | Returns the parent object for the specified object. Read-only. |
| ModelRelationships | |
| DetectRelationships (Method) | Detects model relationships in the specified Pivot Table. |
| PivotField | |
| AutoGroup (Property) | Automatically groups the pivot fields in a pivot table. |
| Point | |
| IsTotal (Property) | True if the point represents a total. Read/write Boolean. |
| Queries (new) | The collection of WorkbookQuery objects |
| Add (Method) | Adds a new WorkbookQuery object to the Queries collection. |
| Application (Property) | When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only. |
| Count (Property) | Returns an integer that represents the number of objects in the collection. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long. |
| FastCombinr (Property) | True to enable the fast combine feature, as long as the workbook is open. Read/write Boolean. |
| Item (Method) | Returns a single object from a collection. |
| Parent (Property) | Returns the parent object for the specified object. Read-only. |
| Series | |
| ParentDataLabelOption (Property) | Specifies the parent data label option (banner, overlapping, or none) for the specified series within the chart group. Read/write XLParentDataLabelOptions. |
| QuartileCalculationInclusiveMedian (Property) | True if the series uses an inclusive median quartile calculation method. Read/write Boolean. |
| Shapes | |
| AddChart | use AddChart2 instead |
| SlicerCache | |
| ClearManualFilter | (Hidden in 2016) |
| SoundNote (new) | Represents a recorded sound note. |
| Application (Property) | When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long. |
| Parent (Property) | Returns the parent object for the specified object. Read-only. |
| Delete (Method) | Deletes the sound note. |
| Import (Method) | Imports the specified sound note. |
| Play (Method) | Plays the sound note. |
| Record (Method) | Records the sound note. |
| Workbook | |
| CreateForecastSheet (Method) | If you have historical time-based data, you can use CreateForecastSheet to create a forecast. When you create a forecast, a new worksheet is created that contains a table of the historical and predicted values and a chart showing this. A forecast can help you predict things like future sales, inventory requirements, or consumer trends. |
| WorkbookQueries (new) | An object that represents a query that was created by Power Query. |
| ?? | ?? |
| WorkbookQuery | |
| Application (Property) | When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long. |
| Delete (Method) | Deletes this query and its underlying connection and removes it from the Queries collection. |
| Description (Method) | The description of the query. Read/write String. |
| Formula (Method) | The Power Query M formula for the object. Read-only String. |
| Name (Method) | The name of the query. Read/write String. |
| Parent (Property) | Returns the parent object for the specified object. Read-only. |
| WorksheetFunction | |
| Forecast_ETS (Method) | Calculates or predicts a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm. |
| Forecast_ETS_ConfInt (Method) | Returns a confidence interval for the forecast value at the specified target date. |
| Forecast_ETS_Seasonality (Method) | Returns the length of the repetitive pattern Excel detects for the specified time series. |
| Forecast_ETS_STAT (Method) | Returns a statistical value as a result of time series forecasting. |
| Forecast_Linear (Method) | Calculates, or predicts, a future value by using existing values. The predicted value is a y-value for a given x-value. The known values are existing x-values and y-values, and the new value is predicted by using linear regression. You can use this function to predict future sales, inventory requirements, or consumer trends. |
Events
No new events were added in 2016.
To see a list of all the events, please refer to the Events page.
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext