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
I am looking for any other suggestions