locked
How to share pivot table via email or otherwise RRS feed

  • Question

  • I work in a company where we don't have sharepoint (I think that's what is used to share files, right)? Is there a way that I can share the functionality of the pivot table I create (allow them to 

    If this is not possible what are the "next steps" for facilitating ease of use in terms of sharing ad hoc reports and dashboards created with power pivot? 

    Tuesday, November 15, 2016 12:49 AM

Answers

  • Yes, SharePoint Enterprise is the tool to publish power pivot workbooks. Have you tried PowerBI.com? Here is a free tier and power pivot technology is the same.

    Self Service BI Expert using Power Pivot http://exceleratorbi.com.au

    • Marked as answer by AlexMartini Tuesday, November 15, 2016 9:02 PM
    Tuesday, November 15, 2016 10:08 AM
    Answerer

All replies

  • Yes, SharePoint Enterprise is the tool to publish power pivot workbooks. Have you tried PowerBI.com? Here is a free tier and power pivot technology is the same.

    Self Service BI Expert using Power Pivot http://exceleratorbi.com.au

    • Marked as answer by AlexMartini Tuesday, November 15, 2016 9:02 PM
    Tuesday, November 15, 2016 10:08 AM
    Answerer
  • Hey Matt. Yeah, I've worked with powerbi.com, the issue is that I can't share my data on there because it's company data so I can't just send a link to a co worker. How difficult is it to set up sharepoint enterprise and is it very costly? I suppose I could research myself :) Thanks. 
    Tuesday, November 15, 2016 9:02 PM
  • It is unlikely you would ever set up SharePoint Enterprise yourself.  If you company has it, you can use it.  If not, then I recommend you use an outsourced provider like http://www.portalfronthosting.com/  I have used them for a few years and they are great.

    Read my blog post about how to do it (and watch my PASS BACON recording) here 

    http://exceleratorbi.com.au/using-sharepoint-enterprise-with-power-pivot/


    Self Service BI Expert using Power Pivot http://exceleratorbi.com.au

    Tuesday, November 15, 2016 9:13 PM
    Answerer