Advertising Console

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

    Repost
    Bill Jelen

    by Bill Jelen

    21
    541 views
    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...