Learn Excel from MrExcel - "Pivot to Range": #1456

Two Pivot Table questions from my Power Excel Seminar in Detroit, MI. First, when I drill down on a pivot table in Excel 2007, I'm getting the Table Format, not just a Range. How can I get the Range? Second, when I convert a Pivot Table to Values...