Pivot tables created using Excel Data VERSUS Pivot Tables created using PowerPivot - Differences?

Posted on 2013-08-28
Medium Priority
Last Modified: 2013-09-01
Can someone tell me what the additional features are between a pivot table created in plain vanilla Excel versus a pivot table created using PowerPivot.
Question by:brothertruffle880
1 Comment
LVL 12

Accepted Solution

duttcom earned 2000 total points
ID: 39447828
My understanding is that PowerPivot can handle more data and can bring it in from more sources. I believe that PowerPivot tables can be created by users and published to a Sharepoint site. I have not done that myself, so I am assuming it would use a data model to do that.

This is a good article - http://blogs.office.com/b/microsoft-excel/archive/2010/10/01/top-5-ways-powerpivot-helps-excel-pros.aspx

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

586 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question