[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 258
  • 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

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

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