Pivot Table Format

Giganews Newsgroups
Subject: Pivot Table Format
Posted by:  cer9 (cer9.28mycm_1149018000.6624@excelforum-nospam.com)
Date: Tue, 30 May 2006

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?action=getinfo&userid=33651
View this thread:http://www.excelforum.com/showthread.php?threadid=546843

Replies