How to keep the cell borders of the pivot table?

  • Thread starter Thread starter Á÷À˵ÄË«Óã
  • Start date Start date
Á

Á÷À˵ÄË«Óã

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

Make sure you have selected "Preserve Formatting" in the table options
 
Yes. I am sure I have selected "Preserve Formatting" in the table options


"David Heaton" <[email protected]>
??????:3c91c9ce-2759-4d28-a7c9-053433508082@u20g2000prg.googlegroups.com...
Is there any way to not lose border formatting after refreshing a Pivot
Table?
Thank you.
Click to expand...

Make sure you have selected "Preserve Formatting" in the table options
 
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 Pivo
Table
Thank you.

EggHeadCafe - Software Developer Portal of Choice
WCF Workflow Services Using External Data Exchange
http://www.eggheadcafe.com/tutorial...a-6dafb17b6d74/wcf-workflow-services-usi.aspx
 
Back
Top