ModelConnection Object (Excel)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Contain information for the new Model Connection Type introduced in Excel 2013 to interact with the integrated data model.

To use for all PivotTables connected to the model, there will have a new “special” workbook connection which always exists (and cannot be deleted) in workbooks which have a data model. It gets created when the model is first created in a workbook. All properties on this special workbook connection are read-only. Its name is:Workbook Data Model.