Pivot Table Update

[kmclean01]

I have created a pivot table based on data in a different file. The pivot table includes a Page Field that is usually a number between 1 and 12. In the data file, I recently changed the numbers to Jen1, Jen2, Jen3, etc. I refreshed the pivot table and the Page Field correctly displayed the list of Jen1, Jen2, etc. I changed the data file back to the original numbers 1 - 12. I refreshed the pivot table and the Page Field is now showing Jen1, 2, 3, etc. I have double checked the data file and there are no cells with Jen1. I have tried refreshing the pivot table, closing the pivot table file without saving and starting over (same results) and changing the data file back to all Jen1, Jen2, Jen3, etc - then the Page Field lists 1, Jen2, Jen3, etc.

I am looking for any other suggestions

 

[Fazza]

hi. please refer http://www.contextures.com/xlPivot04.html

 

[kmclean01]

Fazza,

Thank you...that works perfectly.