PowerPivot beginner

If I have an existing Pivot table can I open that in powerpivot?  or do I have to recreate from the source data?
BigWill5112Asked:
Who is Participating?
 
Rory ArchibaldConnect With a Mentor Commented:
PowerPivot does not 'open' pivot tables. You will need to load the source data into tables in PowerPivot if you wish to use the PowerPivot functionality.
0
 
Leo TorresSQL DeveloperCommented:
well it depends is your data in columns and rows if so it should pick it up and create a pivot window for you to do pivots...

its hard to see no file was attched..

upload a file with fake data
0
 
BigWill5112Author Commented:
So just to clarify you can't take a pivot table that you have setup like you want...you know the right columns, the right row order, the right groupings..you can't convert it to a powerpivot to use some of the powerpivot functionality...like slicers or what if analysis?  I have to use the source data of the original pivot table and import into a powerpivot and recreate the pvitot table??  Thanks for your help.
0
 
Rory ArchibaldCommented:
Correct.
0
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.

All Courses

From novice to tech pro — start learning today.