Excel 2007 : Pivot Tables

[j_Southern]

In earlier editions of Excel it was easy to find the data source of a Pivot table. This was useful if the source was dynamic and did not include all the data in an Excel worksheet.
I cant find how to do this in Excel2007

I am just in that sort of difficulty now, with a data source dynamic in rows, but always including the same columns.. When I change the data and refresh the pivot I get odd results. I believe this is due to the fact that the pivot only looks at the new data in the range of the old data and ignores new data outside that range.

I need to be able to highlight the range being used as data as I could before.

The other problem I shall have to solve is how to specify the range the pivot must look at.
Help on one or both these problems would be a tremendous help.
Thanks in advance
John

[Palmetto]

Its even easier in Excel 2007 to view/change the data source.

1. Click into the Pivot Table
2. In the Ribbon menu, near top right, look for Pivot Table Tools, click this.
3. In the Ribbon, now look for Pivot Data Source and click this, you're now back to same point as in prior versions.

You may now specify the range of data for the PT.
I suggest you either create and use dynamic named range as the source for the PT, or convert the data range to an Excel Table (Insert > Table) and base the PT on the Table.
Tables are automatically dynamic and the PT will recognize changes in the data (new or deleted rows).

[DonkeyOte]

In earlier editions of Excel it was easy to find the data source of a Pivot table.

In addition to Palmetto's points remember too that you can still invoke the old PT Wizard via old keyboard short cut of ALT + D -> P
(if activated on an existing Pivot click "Back" to see the source definition etc...)

You can add the PT Wizard to your QAT

[j_Southern]

Palmetto & Donkeyote,
Thank you very much for your clear and relevant help. As you say it is as easy as ever to find the data source. Please believe me though when I say I had spent hours trying to find the answer before I approached the forum. I find the Excel help system almost useless except for very straight forward questions. Thank goodness for folk like yourselves.
John