Episode # 679 - Pivot Source Data

Change pivot table source in Excel 2007.

Sponsored by

Check out this book for more tips
similar to this lesson!

Thursday, January 24, 2008

Dan asks another Excel 2007 question. How can you re-specify the source data for a pivot data in Excel. It used to be simple to do this in the pivot table wizard, but it is not obvious how to find the pivot table wizard in Excel 2007. In Episode 679, I will show you how to solve the problem in Excel 2007. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

You don't need to go spend an entire day at the local computer chain store to learn Excel. Take 2 minutes to learn this lesson now with our free video!

Watch Video

Click Play icon to play the video. You might first need to click on the Video to activate Flash player.

Tags/Keywords for this video: 2007, PivotTable, Change Data Source

Episode # 679 - Pivot Source Data

Change pivot table source in Excel 2007.

More Excel Video Lessons