Excel - How to keep the cell borders of the pivot table?

Asked By Á÷À˵ÄË«Óã on 07-Aug-09 12:26 PM
Is there any way to not lose border formatting after refreshing a Pivot
Table?
Thank you.




David Heaton replied on 10-Aug-09 07:29 AM
Make sure you have selected "Preserve Formatting" in the table options
????? replied on 14-Aug-09 11:08 PM
Yes. I am sure I have selected "Preserve Formatting" in the table options


??????:3c91c9ce-2759-4d28-a7c9-053433508082@u20g2000prg.googlegroups.com...

Make sure you have selected "Preserve Formatting" in the table options
jake1729 replied on 22-Aug-09 05:26 AM
I am having the same problems in Excel 2007.  Is there a solution?

..
Cruzin1957 replied on 19-Sep-09 09:35 AM
The easiest way I have found to keep the format in Excel 2003 Pivot Tables is to change the Table options by deselecting the Autoformat Table.  I then apply my desired format to the table.  Although it takes a little bit longer to format the table, you will find that it no longer reformats when you make changes.



Posted as a reply to:

How to keep the cell borders of the pivot table?

Is there any way to not lose border formatting after refreshing a Pivot
Table?
Thank you.

EggHeadCafe - Software Developer Portal of Choice
WCF Workflow Services Using External Data Exchange
http://www.eggheadcafe.com/tutorials/aspnet/3d49fa0d-a120-4977-842a-6dafb17b6d74/wcf-workflow-services-usi.aspx