Power Pivots


Board Regular
Jun 1, 2006
Hi guys

Hopefully I'm not breaking the rules by posting this question here...

Are Excel PowerPivots any good? worth me getting to grips with? (I'm now starting to use alot of data and pivots)

And completely free?

Be good to get your views if you know about these...



Derek Brown

Well-known Member
Dec 26, 2005


Board Regular
Apr 29, 2014
Dont think about PowerPivot as an improved Pivot table in Excel. Its a complete different tool that uses Excel as Interface. With PowerPivot you can build a kind of cube with data from different sources, add calculations and create reports out of this. You can do this without much IT support within the business departments.

you should also have a look on this page to decide if its worth your time to test PowerPivot
What is PowerPivot? « PowerPivotPro

PowerPivot itself is free as long as you refresh the data yourself and use Excel as Report tool. If you want more automation, schedule the refresh of your PowerPivot files and show the results as Web reports you need a Sharepoint Enterprise Server that costs some money and a license for every user of the report. There are some other options beside Sahrepoint but all of them are not for free as well.

Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...