If you’ve been using the Excel 2016 Preview or just Excel 2016 (depending on when you read this), you may have noticed that there is no longer an option to insert a Power View report into o workbook. The reason is that it has been removed from the default ribbon in Excel 2016. It used to be on the Insert tab in the Reports Section, right beside Power Map.
Power View in Excel 2013
However, opening the Insert tab in Excel 2016 reveals it to be missing.
Power View Missing in Excel 2016
Did Microsoft remove Power View from Excel? What’s going on? Power View is still very much a part of Excel; the only change is that now it is no longer a default ribbon option. The good news is that it’s simple enough to add it back in. To do so, we need to edit the ribbon. Click on File-Options, and then select Advanced Options. The ribbon editor will appear. We can add Power View to any tab that we would like, or even create a new one, but here we’re just going to add it back to the Insert menu. To do so, expand the Insert menu. Each command must be added to a group, so we need to click the “New Group” button. Next, because I don’t think anyone will want their group named “New Group”, we want to rename it. In this case, we’ll rename it to “Reports”, the way that it used to be.
Adding a new group to the Insert tab
Next, we need to add Power View into the group. The easiest way to do this is to select “Commands Not in the Ribbon” from the “Choose commands from” dropdown. It’s a long list of items to choose from, and you’ll be tempted to look under “P” for Power View. You will be disappointed. The correct command is actually to be found in the “I”s, and it is “Insert a Power View Report”. Select that option, and click the “Add” button.
Once this is complete, Power View should once again appear in the Insert tab, in the Reports section.
I have no idea why Power View has been removed from the ribbon by default. It may just be temporary given that we’re not yet at release, but it could signal some other change. In any event, if you work with both Power View and Excel 2016, you can continue to do so.
Hello John,
Maybe because of new/comming Power-BI functionalities replacing the need for Power-view in Excel??
Rgrds.,
Ronald
OMG I was trying to understand why power view is not there for days! Thank you very-very much for this post!
Thank you!
thanks, John. I met the same problem and found your articles.
also I found microsoft kb regarding to the missing tab.
https://support.office.com/en-us/article/Known-issues-in-Office-2016-Preview-9a472f43-96dc-4671-ac32-9c673edf3221
Power View command is missing
Power View command is missing on the Insert ribbon.
We’re working on a fix and will release it as soon as possible.
[…] View is still Power View, but as John White points out here it is no longer visible on the ribbon by default, hidden from new users, although it’s easy to […]
Thank you very much Sir…
Hi ! Thank You for this post, but it still don’t work ? I’ve got the Powerview command, but nothing happens when I clicked on it, any ideas ?.
Thank you very much!
very useful. I have managed to install the button but nothing happen when I click on it. Any idea why? I have read somewhere else that it could be related to the package that you have. In my case I have the top package and it still does not work.
Thanks for your help,
it might be office pro, but if just have home and office it can not be had, My best guesse that it is a marketing trick to give them more money but bu going to pro and office 365 pro and BI.
.
Very clear instruction! Totally a life saver. Thank you very much
I inserted the “insert a new powerview report” command but power view does not launch nor it can read old powerview reports. I have microsoft office 365 2016 professional plus 64 bit and Microsoft Silverlight (64-bit) Version: 5.1.41212.0 and 64 bit windows 10. What I am missing here? Thanks
The problem could be with silverlight. I previously used 2013 pro plus and then upgraded to 2016 pro plus. I removed silverlight and clean installed. It worked.
you can also find some interested discussion on the same topic here:
https://social.msdn.microsoft.com/Forums/silverlight/en-US/1c3e47b9-2c2a-4e5c-b291-4825902a8423/microsoft-silverlight-version-51404160-doesnt-work-with-power-view-excel-64bits?forum=silverlightgen
https://social.msdn.microsoft.com/Forums/en-US/d1ed0575-6465-4739-a8b3-35a88fef39e6/silverlight-and-ms-excel-powerview?forum=silverlightgen
Thank you,
I had added Power view but didn’t get any response when i click on Powerview.
do we have any other application to be install to use powerview.
Helpful post John!
Extremely helpful!
Thank you!
[…] http://whitepages.azurewebsites.net/2015/07/power-view-excel-2016/ […]
I was already blaming the IT guys 😀
Thank you!
Without this I am feeling very helpless. Thanks a lot…. Cheers….!!!
You are the ‘GoTo’ person ! You really helped me set up the power viewer I had tried steps from various sites and it was your scree shots and explanation that helped.
Thank you! It worked for me! In my case the Powerview would sometimes show and sometimes not… now its there all the time
Power BI Desktop – use that instead
Thanks it has been helpful to me. Stay blessed
I’m able to add the Power View button in the ribbon but clicking on it does nothing. Running 64-bit Excel 2016 on Windows 7. (Office 365 Business Premium)
Having the same issue with 32-bit Excel 2013 on 64-bit Windows 10 Pro (Home and Business 2013). The latest Silverlight x64 is installed on both machines.
So this has been an ongoing issue for years now with no resolution. That tells me MS has no intention of fixing this and instead is trying to push users to PowerBI desktop.
Fantastic! Thank You for the help.
Very Helpful thanks
I’m a Power View newbie, so I thought I’d check it out. Its told me to install Silverlight. However from what I know Silverlight is an end-of-life technology, not so? Why would M’soft still rely on that? If so, I’ll battle to get my Stalinist IT department to allow me to install it.
Hey Walt… PowerView is pretty much end of life too. I wouldn’t bother. If I were you I’d focus solely on Power BI or use the built in Visuals. In fact Excel is getting the Power BI visuals soon too – no need for Power BI
Why do Microsoft make things hard for us? So it look like they want you to download Power BI desktop instead and then push you towards a subscription
I really appreciate your guidance here; I had been looking all over to figure out whether Power View was even included in my Office 365 Home subscription, and am very glad that it is. Microsoft provides ZERO guidance on this. and their Power View tutorials have not been updated since Excel 2013. Thank you for ending my search and my misery…