Excel 2007 : Pivot Tables

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