• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4812
  • Last Modified:

PowerView Button Missing From Excel 2013 Pro Plus Insert Tab

As a follow-up to question 28375061 I cannot see the PowerView button on the Insert tab.  I don't even see a Reports button group.

I've verified the following:
  • Office subscription = Office 365 Pro Plus
  • Excel version 15.0.4841.1002
  • Microsoft Office PowerPivot for Excel 2013 add-in is active
  • the Power View add-in is active
  • the registry entries referenced in MSKB article 2805999 exist
  • the two registry entries for PowerView are set to LoadBehavior 3 (not 2)
  • I have full permission to the two registry entries for PowerView (EE question 3837506)

(The link for MSKB article 2805999 couldn't be used in the bulleted list above because of nested tags.)

Is there anything else I can check?  PowerPivot works just fine.

Alan Varga
Alan Varga
  • 4
  • 2
1 Solution
The BI features need to be installed on both SharePoint and Excel. Take a look at this MSDN article for more information: http://msdn.microsoft.com/en-us/library/hh231671.aspx
Alan VargaAccess DeveloperAuthor Commented:
Are you telling me I won't be able to use PowerView in Excel unless I also use SharePoint?  That's disappointing.

(BTW, your link retrieves "Installation for SQL Server 2016".)
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Alan VargaAccess DeveloperAuthor Commented:
Thanks for the updated link; there's lots of good beginner information there.

Unfortunately, I still have no way to access PowerView.  It seems like I should be able to use the standalone version in Excel without concern for SharePoint.  I have attached screenshots of what I do have, and it coincides with what I read about first-time use.
Office 2013 FeaturesEnabled and Disabled Excel AddinsSilverlight VersionMy Insert Ribbon
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
Are you just missing the button?  I tried this on excel 2016 and it worked https://support.office.com/en-us/article/Turn-on-Power-View-in-Excel-2016-for-Windows-f8fc21a6-08fc-407a-8a91-643fa848729a

In short; go to File > Options > Customize Ribon.

On the right side go to main tabs and open up and highlight the Insert tab.  At the bottom click on new group and rename your group to whatever you want.

Now with the new group highlighted, on the left side use the drop down to get to, "Commands Not In The Ribbon" and find Insert Power View Report.
Alan VargaAccess DeveloperAuthor Commented:
Thanks Scott; I think that's going to do it.  I successfully added the button to a custom ribbon, but I'll have to wait until tomorrow to try it out.
Alan VargaAccess DeveloperAuthor Commented:
Scott was able to find me an excellent workaround, even though my original setup issue is still unresolved.  Thanks for the deep research to get exactly the right Microsoft support article!
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.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now