Connections in Excel 2016

I have created a process to connect data from one workbook into a specific place in another workbook in Excel 2013, but my client has 2016 and I can't find the tick box 'Add this data to the Data Model' in Existing Connections, which is where is it in 2013.

Can anyone point me in the right direction?
Who is Participating?
Change your default file format in Excel to *.xlsx, this is the file format for newer Excel versions.

To enable Power Pivot:
File - Options - Add-Ins - Select COM Add-Ins.... --Activate Microsoft Power Pivot for Excel.

Check if you see now the checkbox you are missing...

I would connect "data model" with Power-Pivot. Is Power Pivot enabled in your Excel 2016?
Is the default file format *.xlsx or do you work with *.xls files?
LillyCAuthor Commented:
I'm on Excel 2013 and my clients on 2016, but I don't think they had Power Pivot enabled. My default file format is*.xls, I will check my clients tomorrow when I log on remotely.

Could you please let me know how I enable Power Pivot and will I easily be able to connect the 'data model' as I'm not familiar with this.
LillyCAuthor Commented:
Perfect - I can now see the missing checkbox, thanks Bembi : )
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.