Pivot tables

Posted by Towards excellence PM | on Mon, 12/03/2012 - 09:39 981 10 comments | report

Hello

I have a pivot table in Excel 2010, on a separate sheet from the source data. This separate sheet is in the same workbook.

Now I have added rows in the pivot table, I cannot see in Excel 2010 how to tell the pivot table to pick up the extra rows (I recall in earlier versions that there was an option to change the data source).

Can anyone help?

Many thanks - SA

Comments

There are 10 comments. Login or register to view them.

PivotTable data source

shurst | Mon, 12/03/2012 - 10:07

Yes!!!!!!!!

Towards excellence | Mon, 12/03/2012 - 10:23

Good

shurst | Mon, 12/03/2012 - 10:37

Another way...

fluffymitten | Fri, 16/03/2012 - 15:18

But..

shurst | Fri, 16/03/2012 - 15:47

Thank you for the extra input

Towards excellence | Fri, 16/03/2012 - 16:42

Just to clarify...

fluffymitten | Fri, 16/03/2012 - 17:48

Why not use the name directly?

shurst | Fri, 16/03/2012 - 18:06

Sorry - 'data' is the sheet name

shurst | Fri, 16/03/2012 - 18:17

More apologies

shurst | Fri, 16/03/2012 - 18:39