Reply to thread

Message: [QUOTE="clifton, post: 3001265"] 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. [/QUOTE]