Are you sure you haven't copied and pasted the table as values, as this would
give the appearance you have just described. is the pivot table still
functional in that you can drag fields around and have it update in front of
you?

Regards
Ken...................

"Sim" wrote:

Hi,
When I go back to a pivot table I have set up, the drop down arrow within
all the fields disappears. Does anyone know how I can retrieve these? Is
there some kind of function to turn this on/off?

thanks