“I thought you could only rely on automatic relationship detection in O365 Home Excel 2016? At least I haven't seen anyway of managing table relationships directly; is there a way to do this? I don't have the 'Manage Data Model' option in Excel 2016 as supplied with O365 Home”
“thanks! I thought all the PowerX suite wasn't available to office home 365 subs. Any plans to include PowerPivot in all Office365 subs too?”
“'May 2016 updates for Get & Transform in Excel 2016 and the Power Query add-in' & 'Updates outlined in this blog are available as part of an Office 365 subscription'
from the O365 Home product page;
'Office 365 Home includes: Fully installed Office applications (Now includes the new Office 2016 apps)'
'Always have the latest, fully installed versions of Word, Excel, PowerPoint, OneNote, Outlook, Publisher, and Access and capture your ideas however you work best—using a keyboard, pen, or touchscreen.'
So i'll be receiving this update through my Office 365 Home subscription?
“the advertising for O365Home and Personal for Windows is misleading too. Its advertised as full office 2016 apps when actually you don't get fully installed Excel 2016 with the O365 subscription because you don't get PowerPivot”
“No, not as far as i can tell anyway
Despite selling O365Home as 'Fully installed Office applications' and extolling the virtues of an O365H subscription over the standalone one time purchase Office 2016 install it is not made clear that O365H does not include PowerPivot whilst the standalone Office 2016 does.
If you want PowerPivot through an O365 subscription then you need O365 Pro Plus, O365 E3 or O365 E4. In other words you need to pay for a business or enterpise O365 subscription