Learn Excel Episode 679: Pivot Source Data
Dan asks another Excel 2007 question. How can you re-specify the source data for a pivot table 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.