I have spent six hours today trying to get an answer as to whether I can replace the version of XL that is part of Office 365 Home on one of my machines (the one I use, of course) with XL 2013/16 standalone. Unlike the 2013 debacle, Office 2016 *does* offer Power Pivot in the Pro SKU that’s available for retail purchase:Purchase and Download Office 2016 Pro from Amazon Here What About Excel Standalone?YES, Power Pivot WILL be included in the Standalone Excel SKU as well, but that is not available yet for purchase.UPDATE: Power Pivot in Excel 2016 Standalone is now available here! What Versions of Office 2016 do NOT Include Power Pivot?Just to be clear, here are some Office 2016 versions that we are positive do NOT include Power Pivot:There also may be other versions that don’t include Power Pivot (for instance we are currently unsure about Office 365 University), so please don’t treat this as an exhaustive list, but those above are guaranteed NOT to have Power Pivot.I seem to have come across one issue and that is that it seems that Excel 2013/2016 Standalone seem to exist in a no-mans land between the sales to business and the sales to consumers sides of MS. Excel for Mac does not support PowerPivot and Pivot Charts.Power Pivot *IS* included in the following Office 365 Plans:Office 365 E4 andE5 Good News: It’s Also Back in Pro Retail!For those of you who prefer non-subscription versions, good news. Versions of Office 365 that DO Contain Power PivotThere was a solution: with the latest 16.x release of Microsoft Office for Mac (released on. This followup helps you decide what version of Office 2016 to purchase.However, it should be possible to have both versions of XL on the same machine.Install Office Hoe 365 and then delete the short-cuts to the 365 Home Version of Excel”. You can try it using the ‘office deployment tool’ (which is meant for ProPlus and other business versions), but it probably won’t work. “No I don’t think you can replace the XL component of home with standalone.
![]() Office 365 Have Powerpivot? Update To TheThe only thing I’ll really miss about 2013/16 is that it can address two screens in one instance -I like that, but can live without it when using PP (I still have XL2016 as part of my Office 365 home subscription). Those people that I know of who have PP at all generally have 2010/V2.Aside from that rereading Rob’s assessment of Excel 2016 most of the most welcome improvements seem to reverting 2013 to how it was at 2010/V2 – so why not go just back there. More crucially, when it does update to the current version that book is no longer editable in 2010/V2. First it didn’t seem to be able to reliably update the data model of workbooks created in 2010/V2 to the new version, some worked, some didn’t. “If you buy the standalone through the MS portal then if it doesn’t install you can have your money back”.Six, no seven hours to get a straight and intelligible answer.Well I bought and tried Excel 2016 standalone and I’ve quickly un-installed it and got a refund. I can’t even copy paste the version here because you can’t copy it anymore (what rationale could there be for disallowing that?). Yet none of the help files say the specific version, just Office 2016, or Excel 2016, which if you look at the “About” page inside the software, that’s what I have. So, all in all I’m going to keep Excel 2010 on my machine and run that with PPV2.Sigh, no wonder none of the help files on support are of any use to me. Thank you for explaining this.I did notice that there is a “power BI desktop” available for download, but it looked more like an “Access for Public Web Databases” so I didn’t look into whether I had to buy it or just download it or whatever. It’s getting to the point where a person has to be an expert on versions of software just to use basic training materials like the aka.ms/10exceltips which is prominently displayed on MS’s office training website. I thought I was buying the whole deal by getting the business one. I had no idea there were so many versions out there. How can i change the font in my adobe document for mac acrobat x proBasic training in the new software is what I’m after.No wonder that the uptake of Power Pivot is so low. I guess I can look into the desktop thing and see if it gets me anywhere but it’s not on my priority list. If the software doesn’t even contain the real world tools… well, enough said about that. This is once again underlining why “education” is really falling out of touch with actual business needs. ![]()
0 Comments
Leave a Reply. |
AuthorTim ArchivesCategories |