Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Oct 2001
    Location
    Toronto, CANADA.
    Posts
    292
    Thanks
    21
    Thanked 3 Times in 3 Posts

    Smile "upgrade" of pivot table

    hello everyone;

    i already have a pivot table in a spreadsheet.

    i am using office 2007 [O2K7].

    to the data table upon which the pivot is based, i added two more rows.

    in office 2003, there was an instance of invoking again the wizard, and the ability to expand the basic range.

    i cannot find this in O2k7, and i dead having to rebuild (from scratch) a new pivot table.

    is it there something i cannot see?

    TIA for your help.

    daniel rozenberg.

  2. #2
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Levin, Manawatu-Wanganui, New Zealand
    Posts
    324
    Thanks
    9
    Thanked 28 Times in 26 Posts

    Change Data Source

    Hi

    Excel 2010
    You would look for the contextual tab Named "Options" under the "PivotTable Tools" .
    On there you will find a button named "Change Data Source".

    excelPTChageSource.PNG

    Geof

  3. The Following User Says Thank You to geofrichardson For This Useful Post:

    danielr2 (2015-10-12)

  4. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Levin, Manawatu-Wanganui, New Zealand
    Posts
    324
    Thanks
    9
    Thanked 28 Times in 26 Posts

    Enable Old Pivot table Wizard ?

    Show Office 2003 Pivot Table Old Wizard

    Can you do this in Excel 07

    • Right Click in PT
    • Select Pivot Table Options
    • Choose the Display tab


    PTOptions.PNG

    Cheers
    Geof

  5. The Following User Says Thank You to geofrichardson For This Useful Post:

    danielr2 (2015-10-12)

  6. #4
    3 Star Lounger
    Join Date
    Oct 2001
    Location
    Toronto, CANADA.
    Posts
    292
    Thanks
    21
    Thanked 3 Times in 3 Posts
    HI Geof,

    Thanks for your replies.
    Yess!!!!!!!!!!!!
    I found the PT tools, and upgraded the data source .

    Thank you VERRRRRRRRRRRRRRY MOCH!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •