Power Pivots

AndyDevine1

Board Regular
Joined
Jun 1, 2006
Messages
172
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...

Thanks

Andy
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,267
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top