pivot table refresh
 

Pivot table row fields are not updated properly.
1. data is at a seperate sheet
2. table has rows and columns
3. when we put new data in the sheet,
the rowfield keeps all previous rowfields in its selection list
4. when we change the rowfield into a page-field,
the pagefield shows only the new values.
5. when we change the field from page to row again,
the row field still mentions all OLD values.
What is happening?
* refresh does not help