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?
LillyCAsked:
Who is Participating?
 
BembiCEOCommented:
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...
0
 
BembiCEOCommented:
Hello;

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?
0
 
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.
0
 
LillyCAuthor Commented:
Perfect - I can now see the missing checkbox, thanks Bembi : )
0
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.