Solved

Powerview and power pivot missing in office 365 pro plus excel 2013

Posted on 2014-02-26
6
8,431 Views
Last Modified: 2014-03-05
Hi
I've insalled office365 pro plus and have been trying to enable Powerview and PowerPivot.
These options are no available to turn on in the add ins options.

I've uninstalled and reinstalled without any successs.
Can anyone help please.

Thanks
0
Comment
Question by:broadcastwarehouse
  • 3
  • 3
6 Comments
 
LVL 14

Expert Comment

by:Zack Barresse
ID: 39890986
Hi there,

To install Power View, follow these instructions: http://www.excel2013.info/powerview/
Download Power Pivot: http://www.microsoft.com/en-us/bi/powerpivot.aspx (you may want to check the COM add-ins as well for this, I don't remember if it comes already installed in the ProPlus or not).

You should already see the Power View button on the INSERT tab though. Do you not see it? If not, what version are you running? (To check version go to File, Account, About Excel, tell us the numbers are the top.)

You don't have to reinstall all of Office though.

Regards,
Zack Barresse
0
 

Author Comment

by:broadcastwarehouse
ID: 39891440
There is no option in COM add-ins and there is no option for Powerview on insert tab.

The version we are running is;
Mic. Excel 2013 (15.0.4551.1510) MSO (15.0.4551.1508) 32-bit
Part of Mic. Office 365 ProPlus
0
 
LVL 14

Expert Comment

by:Zack Barresse
ID: 39892637
What COM add-ins do you see? Also, when you click File, Account, you should see an Update button there. Running the update will give you the latest bits of the build. Note between now and one month from now you will be getting service pack 1, as it was released two days ago.

Zack
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Accepted Solution

by:
broadcastwarehouse earned 0 total points
ID: 39894225
Hi Zack
Thanks For your help

Managed to get it fixed.

Followed part of the solution on this page.
http://support.microsoft.com/kb/2805999

Instead of deleting these registry entries below , changed the permissions to allow current user and that fixed it.
Microsoft Office PowerPivot for Excel 2013 add-in
HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\PowerPivotExcelClientAddIn.NativeEntry.1
Power View add-in
HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\AdHocReportingExcelClientLib.AdHocReportingExcelClientAddIn.1
0
 
LVL 14

Expert Comment

by:Zack Barresse
ID: 39895981
Thanks very much for posting the link/fix. :)

Zack
0
 

Author Closing Comment

by:broadcastwarehouse
ID: 39905909
That was the solution to fix the issue
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This article will show you how to use shortcut menus in the Access run-time environment.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

911 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now