I'm new to Excel 2010 coming from 2003 and this forum has been remarkably valuable for me in getting up and running! Thank you so much for all the fabulous video's!!!!
I love, love, love my pivot tables. With 2003, of course, we had that wonderful wizard, with my favorite part being the layout button.
What I cannot comprehend is why I get two different types of layout "wizards" (for lack of a better term) when working with different datasets in 2010? One shows just a box on the left side of the screen with the table options on the right:
https://skydrive.live.com/embedphot...ot Table 1.jpg?cid=8fdab111b2742863&sc=photos
the other shows something similar to my old faithful Pivot table
https://skydrive.live.com/embedphot...ot Table 2.jpg?cid=8fdab111b2742863&sc=photos
-- removed inline image ---
In a perfect world (well, my perfect world), they would always look like the second one. Thoughts on how I can make that happen or why I'm getting the two different formatting types?
Thank you!
Cate
I love, love, love my pivot tables. With 2003, of course, we had that wonderful wizard, with my favorite part being the layout button.
What I cannot comprehend is why I get two different types of layout "wizards" (for lack of a better term) when working with different datasets in 2010? One shows just a box on the left side of the screen with the table options on the right:
https://skydrive.live.com/embedphot...ot Table 1.jpg?cid=8fdab111b2742863&sc=photos
the other shows something similar to my old faithful Pivot table
https://skydrive.live.com/embedphot...ot Table 2.jpg?cid=8fdab111b2742863&sc=photos
-- removed inline image ---
In a perfect world (well, my perfect world), they would always look like the second one. Thoughts on how I can make that happen or why I'm getting the two different formatting types?
Thank you!
Cate
Last edited:
