I'm not sure I understand what you want.

1. To change the page field you simply click on it and drag it away from the
pivot table; the cursor will display a red X, which means if you let go of the
mouse button the field will be gone. Or if the pivot table field list is
showing you simply drag and drop the page field into the pivot table field
list. To put a new/different page field in the pivot table you select a field
from your pivot table field list and drag it into the page position OR select
it, select Page Area from the drop down at the bottom of the pivot table field
list and click the "Add To" button (I'm using Excel 2002, it may be a little
different in an earlier version).

2. Now, to change the source data (where the pivot table pulls its
information from) you right click on any field in the pivot table, select
"Wizard...", and then click the "<Back" button.
- If the data is within the workbook you will see the sheet and the range will
be outlined.
- If the data comes from an outside source, like Access or a SQL db, then you
will click the button that says, "Get Data...", which will take you to the
[external] data source. You are on your own at that point on getting the
data.
--
Toby Erkson
Oregon, USA

"Arien " wrote in message
...
I have made a pivottable that is beeing used by several people.

Now somebody (dead already) has overwritten the pagefield
of this pivottable.
Is there a way to reset the data in a pivottable without having to make
the tabel all over.
It just needs to go back to the original sourcedata.

Thanks,
Arien


---
Message posted from http://www.ExcelForum.com/