Page 2 of 2 FirstFirst 1 2
Results 11 to 17 of 17

Thread: Trouble Installing PowerPivot

  1. #11
    Seeker Will Riley's Avatar
    Join Date
    Mar 2011
    Location
    Solihull, United Kingdom
    Posts
    8
    Articles
    0


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

    Quote Originally Posted by Justin View Post
    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.
    Powerpivot for Sharepoint is quite a different beast. At a high level, it is effectively SQL Server Analysis Services running a Vertipak storage engine (as opposed to the standard SSAS OLAP engine).

    So on an existing Sharepoint (2010 only) "farm", you need to install SSAS in "sharepoint integrated" mode and then you can turn on the Sharepoint powerpivot Services (in the same way you would enable Excel Services, PerformancePoint Services. I believe all the BI components require Sharepoint 2010 enterprise edition, so if you have that you can install and run Powerpivot. It's not an easy task though so i'd recommend a good deal of reading and understanding first

  2. #12
    Thanks Will for the response. It gives a helpful view into what's needed.

  3. #13
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,319
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Hi Justin,

    I'd be leaving the Sharepoint portion to your IT department.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    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.

  4. #14
    It was my intention. If I wanted to touch a server myself, I'd have to pull a stunt like Tom Cruise from Mission Impossible

  5. #15
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,319
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    LOL!

    Hang out with geeks enough and you'll decide to build your own at home some day.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    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. #16
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,601
    Articles
    0
    Excel Version
    O365
    Quote Originally Posted by Ken Puls View Post
    LOL!

    Hang out with geeks enough and you'll decide to build your own at home some day.
    Nah! I am on a SharePoint course today, and it is as bad as I expected.

  7. #17
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,319
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Quote Originally Posted by Bob Phillips View Post
    Nah! I am on a SharePoint course today, and it is as bad as I expected.
    Glad to hear the earth hasn't fallen off it's axis, Bob.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    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 2 of 2 FirstFirst 1 2

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
  •