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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
