Page 1 of 2 1 2 LastLast
Results 1 to 10 of 17

Thread: Trouble Installing PowerPivot

  1. #1

    Trouble Installing PowerPivot



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Ken and all

    Total noob question for you:

    I decided to check out PowerPivot and my beginnings are not auspicious.

    I am running

    Windows 7 Home Premium 64 bit
    Microsoft Office Enterprise 2010

    I downloaded the file "1033\PowerPivot_for_Excel_amd64.msi"

    From this page:
    http://www.microsoft.com/downloads/e...7-4b99c1f3c49b

    I run the executable, I get this message (see attached screenshot).

    I go to the link mentioned in the screenshot, basically takes me back to the download page where I started.

    Can't see where I am going wrong, any thoughts?



    Thanks in advance.
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	pp_install_error.jpg 
Views:	373 
Size:	17.2 KB 
ID:	43  

  2. #2
    Sorry, correction -- "Office Professional Plus 2010", not Enterprise.

    Also, I checked that Office Shared Features and Office Tools were present and accounted for, still no luck sadly.

  3. #3
    Hi Justin...

    I suppose, you are using Excel 2010 32 Bit on a 64 Bit System.
    Did you try the 32 Bit version of PowerPivot?

    The PowerPivot Blog also has an article about Installation issues.
    How to install PowerPivot for Excel and list of know issues.
    Hope, this helps.

    Regards :-)

  4. #4
    Well what do you know...you're right.

    I am going to reinstall Office as 64 bit and see if that works.

    Thanks Mourad!

  5. #5
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,091
    Articles
    79
    Blog Entries
    14
    Hi Justin,

    Powerpivot is a bit different from the other apps out there in that the 32 vs 64 bit is actually tied to the version of Office, not the version of Windows. (Pretty much everything else is opposite.)

    For reference, the biggest thing Office 64 will give you is the ability to make use of more RAM. But if you get into any coding there are transitions that need to be done. You also can't install it alongside any other Office version. (So if you go 64bit, you have 64bit Excel and that's it. If you stay 32bit, you can actually run Office 2003/2007/2010 on the same machine.)

    I've seen quite a few people that have switched back to the 32bit version of Office after using the 64bit version, as they don't feel 64bit is ready.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  6. #6
    Ken, thanks for that. I left on the 32 bit version for now with that in mind, just to spare myself the headache for the time being.

    I've managed to get the add-in installed -- now just to figure out how it works

    If I'm really lucky, perhaps I can get the Sharepoint component set up here at work.

  7. #7
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,091
    Articles
    79
    Blog Entries
    14
    Hey Justin,

    Not really sure how the Sharepoint integeration works for this one. I believe that there is a separate PowerPivot for Sharepoint product that installs on the server, but haven't checked that out yet myself. Regardless, you'd build the model in Excel first, then publish it to Sharepoint anyway, so nothing you do here would be lost.

    As for figuring out how it works... that part is the fun part.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  8. #8
    Right. I think I got the basics figured out. This is pretty awesome indeed.

    Re: the Sharepoint integration, I think you're right Ken, it seems it lets you publish your models to Sharepoint as interactive web apps that can refresh automatically. My guess is the demos on this page are probably using Sharepoint? http://powerpivot.com/demo.aspx

  9. #9
    Seeker XL-Dennis's Avatar
    Join Date
    Mar 2011
    Location
    Östersund, Sweden
    Posts
    12
    Articles
    0
    Ken,
    ... as they don't feel 64bit is ready.
    Can You elaborate it further? I can see that the coding part can be an issue if we use VBA. But what else? I have been running x64 version since it was launched and so far I cannot say it's different then x86 version.
    Kind regards,
    Dennis

    .NET & Excel | 2nd edition PED | MVP

  10. #10
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,091
    Articles
    79
    Blog Entries
    14
    Quote Originally Posted by Justin View Post
    My guess is the demos on this page are probably using Sharepoint? http://powerpivot.com/demo.aspx
    Yep. That's the only way to make it foreward facing on the web like that. (Unfortunatley PowerPivot won't refresh in the free WebApp client.)

    Quote Originally Posted by XL-Dennis
    Can You elaborate it further?
    Oddly enough, I really can't. I've asked for some more on this too, Dennis. I know Zack has had some issues with it.

    My only real issues that were 64 bit related were around the lack of compatible add-ins and programs. MZTools, SmartIndenter, Google Calendar connector & the Office Social Connector haven't all been ported to 64 bit yet. Beyond that I wasn't having any issues. The only reason I uninstalled it was because I needed Office 2007 installed locally to record some Excel video webcasts, and it won't co-exist with 64bit office.

    As far as working in the app... no big issues once I'd got the 64bit code compatibility out of the way.

    I wonder if we should start a new thread on this specific to it. It could be interesting to hear what others impressions are of it?
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Page 1 of 2 1 2 LastLast

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •