Office 2016 is the recommended version of Office 365 ProPlus and includes all the latest upgrades and new features. As we announced in September 2015, when we released Office 2016, beginning March 1, 2017, the Office 2013 version of Office 365 ProPlus will no longer be available for installation from the Office 365 portal.
How does this affect me?
Beginning March 1, 2017, your users will no longer see Office 2013 as an option for download through the Office 365 portal, and admins will no longer have the option under Software download settings in the admin portal to choose to enable Office 2013. In addition, we will no longer provide feature updates for this version, nor provide support.
What do I need to do to prepare for this change?
We recommend you install Office 2016 as soon as possible to have the latest and greatest features and support.
POWER VIEW has been deprecated. Now you must use Power BI Desktop
Presentation of Power View
Power View was a tool in Excel 2013 Pro Plus to create interactive dashboard.
Each element (chart, map, table of value) can interacted with the others.
For instance, if you select a slice of the pie chart, this will filter all the others element according to the selection
Technology of Power View
Power View has been developed with the technology Silverlight. Unfortunately, this technology has been depreciated by Microsoft in October 2012. So it was obvious that Power View in its original state couldn’t evolve.
In fact, in the same time, HTML5 was much more robust, quick and light than Silverlight. So it was necessary for Microsoft to develop a similar tool but base on HTML5.
Power View with Excel 2016
Power View is not visible by default in Excel 2016. Nowhere in the ribbon, you can find it.
For compatibility reason, Power View could be installed by activating the tool from the menu Options>Custom Ribbon
But, that was at the beginning of Excel 2016. It seems in 2018 that none of the Power View dashboard couldn’t opened.
What is the future of Power View?
In fact, now, the best way to create interactive dashboards is to use Power BI Desktop. And there is many reason for that:
The tool is free
You can connect to many different sources
Manipulate easily your data (Power Query)
Create your own measures (Power Pivot)
You have tons of visuals to present your data
Share easily your dashboards to a specific audience
Recently Microsoft has announced a new public update to Excel 2013 that includes major stability and usability improvements in Self Service BI scenarios – especially when Power Query, Power Pivot and Power View are involved. For this release we eliminated over 120 bugs, crashes and hangs and introduced two new important usability improvements that aim to make the analysts’ work smoother.
If you have automatic updates enabled for your Office 365 subscription, you should receive the latest Excel update soon. If you don’t have automatic updates enabled in Excel, go to File>Account>Update Options>Update Now.
If you are running a perpetual Office edition then you will need to install the following updates through Windows Update or Microsoft Download Center – KB2910929, KB2899498, KB2899505and KB2920734.
Power Pivot is a new tool of Excel 2013 that allows you to perform calculations on an unlimited number of rows. The calculation can be done with calculated columns, like in Excel, or with measures.
It all starts with SQL Server
Before to explain how to use Power Pivot, it is important to know that this tool has been developed by the engineers of Sql Server.
SQL Server is a relational database management system developed by Microsoft. It’s interface is SQL Server Management Studio (SSMS). When you use SSMS for the first time and when you are familiar with worksheet, you will be surprised to not visualize your data like you can do with Excel.
In fact, your data are stored, somewhere, but to visualize your data, you have to create a sql query.
So, to visualize the data like in Excel, the Microsoft’s engineers have developed a tool call SQL Server Analysis Services (SSAS)
When you link SSAS to a database, you can see easily the contain of each table like in a spreadsheet. But the data are in View only mode.
SSAS = Power Pivot
At this step, Microsoft has created a tool to connect to database without limitation of rows. That’s the perfect tool to avoid the limitation of Excel.
So, in 2011, Microsoft has integrated SSAS to Office. And because the only way to return the results is in an agregator, and the only agregator of Excel is Pivot Table, SSAS becomes Power Pivot in Office (logic).
Installation of Power Pivot
In the version of Excel 2010, Power Pivot was an add-in but with Excel 2013, Power Pivot was integrated in the native Pro Plus version.