I create a pivot table where the date format from the source data is ENTERED
as mm/dd/yyyy. (1/30/2007) I change the format display in the source data to
dd-Mmm-yy (01-Jan-07). When I create the pivot table, the format is
mm/dd/yyyy. (1/30/2007). OK, same as source data. I want the pivot table
format to be dd-Mmm-yy (01-Jan-07). I can change the format in the pivot
table, but when I refresh the table, the format reverts back to mm/dd/yyyy.
I've tried every combination of Autoformat table and preserve formatting in
the options screen but get the same results. What do I need to do? Thanks.