“upgrade” of pivot table

Topic

New Reply

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.

Reply | Quote

Replies

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”.

42272-excelPTChageSource

Geof

Reply | Quote

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[*]

42273-PTOptions

Cheers
Geof

Reply | Quote

HI Geof,

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

Thank you VERRRRRRRRRRRRRRY MOCH!!!

Reply | Quote