• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 261
  • Last Modified:

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?
0
BigWill5112
Asked:
BigWill5112
  • 2
1 Solution
 
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
 
Rory ArchibaldCommented:
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
 
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now