Pivot tables

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 |
shurst's picture

Yes!!!!!!!!

Towards excellence |

Good

shurst |
shurst's picture

Another way...

fluffymitten |
fluffymitten's picture

But..

shurst |
shurst's picture

Thank you for the extra input

Towards excellence |

Just to clarify...

fluffymitten |
fluffymitten's picture

Why not use the name directly?

shurst |
shurst's picture

Sorry - 'data' is the sheet name

shurst |
shurst's picture

More apologies

shurst |
shurst's picture