I have a pivot table that i make multiple versions by changing the value
in the Page field. The table uses one of the auto formats under the
'format report' menu. The problem I am having is that the table
unformats itself (row height, undo wrap text, background/font color,
etc.) everytime I make a new version of the report. Is there a way to
lock the formats so I don't have to reformat everytime I make a new
version?


--
cer9
------------------------------------------------------------------------
cer9's Profile: http://www.excelforum.com/member.php...o&userid=33651
View this thread: http://www.excelforum.com/showthread...hreadid=546843