i have a macro that creates a pivot table based on some user inputs an
then i do some formatting on the pivot table just for show. th
problem is that i can't maintain the formatting if the user decides t
alter the pivot table (i.e. change one of the field drop downs fro
showing "All" data to some subset of it.)

i've already tried to set the preserve formatting feature to true, bu
that didn't work .... any ideas?

thank

--
gonge
-----------------------------------------------------------------------
gonger's Profile: http://www.excelforum.com/member.php...fo&userid=3479
View this thread: http://www.excelforum.com/showthread.php?threadid=56433