Solved

PowerView Button Missing From Excel 2013 Pro Plus Insert Tab

Posted on 2016-08-05
7
1,678 Views
Last Modified: 2016-08-18
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.

Thanks!
0
Comment
Question by:VieleFragen
  • 4
  • 2
7 Comments
 
LVL 18

Expert Comment

by:xtermie
ID: 41748333
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
0
 
LVL 1

Author Comment

by:VieleFragen
ID: 41748686
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".)
0
 
LVL 18

Expert Comment

by:xtermie
ID: 41748737
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 1

Author Comment

by:VieleFragen
ID: 41750286
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
0
 
LVL 52

Accepted Solution

by:
Scott Fell,  EE MVE earned 500 total points
ID: 41758124
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.
1
 
LVL 1

Author Comment

by:VieleFragen
ID: 41758557
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.
0
 
LVL 1

Author Closing Comment

by:VieleFragen
ID: 41760947
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!
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question